sort recorts

[alex]

i run office 2003 work with access 2003.
i split the address in 2. number and address
ie number "213".address "ross str".and some of the numbers have are
alphanumeric ie "213A".question in design data type i cannot put numbers
because its sometimes alphanumeric and if i put text i will have a problem
sort ascending with numbers.it wouldn't show correctly like
1.2.3.4.5.6.7.8.9. etc any idea on work arounds
syncerly alex

 

[richard]

Try a further field titled 'suffix' for the Alpha element of you field, this
would allow you to have the best of both worlds regarding the text and number
fields


Richard

 

[richard]

re-read my own thread and realised it was poor english
instead of having one field giving a record of 213a
split this as follows

Field 1 Field 2
213 a

hope this helps

 

[John W. Vinson]

i run office 2003 work with access 2003.
i split the address in 2. number and address
ie number "213".address "ross str".and some of the numbers have are
alphanumeric ie "213A".question in design data type i cannot put numbers
because its sometimes alphanumeric and if i put text i will have a problem
sort ascending with numbers.it wouldn't show correctly like
1.2.3.4.5.6.7.8.9. etc any idea on work arounds
syncerly alex

Create a Query based on the table; in a vacant Field cell type

SortNumber: Val([Number])

before the number field itself. Sort by both (so it will sort 214A before
214B).

John W. Vinson [MVP]