mailing labels - do i need a report for every query?? 1

[vacant]

hi, another complete newbie here sent to try your patience...

Ok, I am attempting to use Access to replace the antiquated mail-label software we have at work. So far I have managed to import the data into a table (hurrah!), and have created a rather snazzy-looking form which can be used to amend/add/delete records.

I have calculated that the table needs 40 different queries in order to satisfy all of the possible mail-label requirements. Do this mean I need to create a report for every one of these queries in order to produce the necessary labels? That does seem a little bit long-winded, as each of the label-formats would be the same.

I'm afraid I don't know any VB.

Cheers for any help,
TT

 

[DougP]

No sure you you need 40 queries.

I'm sure that some of those are similar to the others except...

Here is an example:
Say you need to pick different states
FL, IN, IL etc
Instead of having 3 different queries
put this in the crtiteria for one query
[Enter State]
in the state field. When you run it, it will pop up an input box asking for "Enter State".
Then it can work for all 50 states

Also you can use your form to allow for picking different criteria using combo boxes and list boxes.

Then you should only need a few queries. But to answer your question yes you need a report for each differnt query. But the one example I showed above with states, one query and one report. DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[tempclerk]

You can use one report based on one query if you use complicated-enough criteria.
You definitely don't need more than one report - base it on all your records, but only open it WHERE it meets your criteria.