Zip Code Bulk Mail Sort

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walmondo Kelly - 29 May 2007 14:46 GMT

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?

Signature

rjk

Reply to this Message

John Spencer - 29 May 2007 16:01 GMT

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)

Signature

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?

Reply to this Message

Walmondo Kelly - 31 May 2007 15:11 GMT

Thanks. It worked right away.

Signature

rjk

> In a query you can generate the ZIP code with your expression as a separate
> field and sort by that
[quoted text clipped - 13 lines]
> > Can I use this somehow because for bulk mail in the label wizard I need to
> > be able to sort by zip code?

Reply to this Message