I have created a membership application.  Each member maintains two
addresses.  One from the Business and one home address.  One field is
[buszip] and the other is [homezip].  My problem is how to get the labels or
report in a true Zip Code order for bulk mailing.

I have written functions to display and print the correct address based on
each members preference.  Is there a way to sort by this one field or both
fields on the report or labels to get the true zip code order.  This field
name on the report would be [zip].

Can this be done on the report level or any other level for that matter.
Any suggestions or alternatives  would be appreciated.  I have been trying
to do this some months now.  In other words

H E L P

PeteS

Pete

Do the sorting on the report. Look for the Sorting and Grouping button on
the tool bar.

Terry

Using the Sorting and Group does not work.  This reads all business zip and
then the home zips.  These two zips are sometimes different.  The homezips
are thrown in the wrong place as it is reading the BusinessZip.

The reason for all this heartache is the Post Office and Bulk Rate.

Do anyone know if a can sort or group on a report field name?

PeteS

Have you tired running your data through a query with an extra field, called
say, "ReportZip", and setting it to the return value from your function as in:
ReportZip: myFunction([preference],[homezip],[buszip]). Of course, your
function would have to be public.
So ReportZip would now contain the zip you will want to order on. Change the
data source of your report to that query. All your fields should be there, so
there should be nothing new to do, except set your sorting and grouping to the
ReportZip field.

Lyle Fairfield

Pete

I take it that you are selecting to use Business or Home Zip on the report?

Do it in the query that the report is based on and then sort on the created
field say PostZip. Your field would look something like this

PostZip: IIF([Preferred]="Work", {Business Zip], [Home Zip])

In the report you will now have afield PostZip that you can sort on.

Hope this helps

Terry

This worked great.  Thanks for the help.  I figured that it was simple, but
could not come up with the answer.

Thanks to everyone who responded.

PeteS