sort numbers in a query

[Guest]

I am using a text field in a table for an address number, ie 4 Brown Street,
8 Brown Street, 10/12 Brown Street and so on up to 40 Brown Street.

When I try to sort in a query (which runs a form) 10/12 Brown Street is
first and 4 and 8 are last. I have tried the Val function but it doesn't
appear to work. I can't use a number field in the table as a lot of the
addresses have obliques or dashes.

Please help.

 

[Van T. Dinh]

Addresses are always hard to decide on the correct Table Structure. Whether
the Unit / Villa / Apartment number, Street number and Street name should be
stored in separate Fields or store as one Field depends on the usage. In
your case, it is clear that they should be stored in separate Fields as you
need to manipulate some of the components separately.

Rebecca Riordan discussed about this in her book "Designing Relational
Database Systems" if you are interested.

 

[Guest]

Thanks.

Addresses are always hard to decide on the correct Table Structure. Whether
the Unit / Villa / Apartment number, Street number and Street name should be
stored in separate Fields or store as one Field depends on the usage. In
your case, it is clear that they should be stored in separate Fields as you
need to manipulate some of the components separately.

Rebecca Riordan discussed about this in her book "Designing Relational
Database Systems" if you are interested.

 

[Guest]

Thank you for your suggestion.

It has become quite apparent that I am mere novice, however I will put your
good thoughts to use.

emc