By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

sort recorts

P: n/a
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
Jul 15 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have a look at the "Val" function

Phil

"alex" <vz******@verizon.netwrote in message
news:5Xvmi.4457$225.328@trndny03...
>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

Jul 15 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.