sort mixed field

[Guest]

I have 500+ records and want to sort the address field by STREET not by
numeric address (some of the DB records have a new zip code and I want to
sort by street name to have someone quickly review manually to note which
have changed). I have tried to find 'help' in sorting but nothing works. I
could export into excel but my need does not seem possible there either. Can
anyone help? Thanks!

 

[Douglas J. Steele]

Try adding a computed field to your query to use for sorting purposes.

If all the records have an address, followed by a space, followed by the
street name, you could use

Trim(Mid([Address], InStr([Address], " ") + 1))

 

[Guest]

Need a little more detail. Would this be query language in the "where"
command? Or >>>>????? thanks so much.

Try adding a computed field to your query to use for sorting purposes.

If all the records have an address, followed by a space, followed by the
street name, you could use

Trim(Mid([Address], InStr([Address], " ") + 1))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have 500+ records and want to sort the address field by STREET not by
numeric address (some of the DB records have a new zip code and I want to
sort by street name to have someone quickly review manually to note which
have changed). I have tried to find 'help' in sorting but nothing works.
I
could export into excel but my need does not seem possible there either.
Can
anyone help? Thanks!

 

[Douglas J. Steele]

I'd been thinking you'd type that in a blank column on the Field row in the
query builder, although there's no reason you couldn't go into the SQL view
of the query and put it in the Where clause (it'll amount to the same thing
when you go back into Design view)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Need a little more detail. Would this be query language in the "where"
command? Or >>>>????? thanks so much.

Try adding a computed field to your query to use for sorting purposes.

If all the records have an address, followed by a space, followed by the
street name, you could use

Trim(Mid([Address], InStr([Address], " ") + 1))

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have 500+ records and want to sort the address field by STREET not by
numeric address (some of the DB records have a new zip code and I want
to
sort by street name to have someone quickly review manually to note
which
have changed). I have tried to find 'help' in sorting but nothing
works.
I
could export into excel but my need does not seem possible there
either.
Can
anyone help? Thanks!

 

[Joseph Meehan]

I have 500+ records and want to sort the address field by STREET not
by numeric address (some of the DB records have a new zip code and I
want to sort by street name to have someone quickly review manually
to note which have changed). I have tried to find 'help' in sorting
but nothing works. I could export into excel but my need does not
seem possible there either. Can anyone help? Thanks!

I know this is a little last, but this is one reason it can be
advantageous to keep the number portion in a different field than the street
name. Of course then there are other possible problems.