Then the text values
will sort in the expected order: 001, 002, 003, 004, 005, 010, 100.
n Is the data text or date data? When working with dates, you??™re almost always better off
storing the data in a Date/Time field than as a Text field. Text values sort differently
than date data (dates are stored internally as numeric values), which can upset reports
and other output that rely on chronological order.
n Keep in mind the reports that will be needed. You won??™t be able to sort or group
memo or OLE data on a report. If it??™s important to prepare a report based on memo or
OLE data, add a Tag field like a date or sequence number, which can be used to provide
a sorting key, to the table.
Text data type
Any type of data that is simply characters (letters, numbers, punctuation). Names, addresses, and
descriptions are all text data, as are numeric data that are not used in a calculation (such as telephone
numbers, Social Security numbers, and zip codes).
Although you specify the size of each Text field in the property area, you can enter no more than
255 characters of data in any Text field.
Pages:
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255