Zip Code Bulk Mail Sort

[Guest]

I have city state zip in a limited list in a combo box which makes date entry
easier and faster. I have stripped the zip on the form with =Right([zip],5)
Can I use this somehow because for bulk mail in the label wizard I need to
be able to sort by zip code?

 

[John Spencer]

In a query you can generate the ZIP code with your expression as a separate
field and sort by that

In a report you can either generate the value in a query and then sort by
that using the report's sorting and grouping dialog. Or enter the formula
in the sorting and grouping dialog of the report (found under the menu View:
Sorting and Grouping)

Field/Expression
=Right([Zip],5)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks. It worked right away.
--
rjk

In a query you can generate the ZIP code with your expression as a separate
field and sort by that

In a report you can either generate the value in a query and then sort by
that using the report's sorting and grouping dialog. Or enter the formula
in the sorting and grouping dialog of the report (found under the menu View:
Sorting and Grouping)

Field/Expression
=Right([Zip],5)

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I have city state zip in a limited list in a combo box which makes date
entry
easier and faster. I have stripped the zip on the form with
=Right([zip],5)
Can I use this somehow because for bulk mail in the label wizard I need to
be able to sort by zip code?