How do I set up labels by alpha & zip code & count?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up labels that can be alphatized, moved when a new name is
added and also be put together by zip code.

I would like a form that would tell me how many labels are in each zip code
and also a total of labels printed.
 
To sort the labels, add another column in the report query that will contain
zip and name (like 60260-Smith.. etc.). Sequence the report (labels) on
this column.

To get the total number of labels, and the number of labels in each zip, I
think an additional query that sorts, summarizes and counts the records
based on zip code would do it. It'll take two columns --- zip code and a
count of the recordsYou can point the count column at the primary key since
it'll be unique). Sort this on zip code. You'll then either need a form to
read this in and display it to the user, or a report to print out the
information.
 
Back
Top