Generate multiple reports from list.

Good Afternoon,

I have a query that selects information based on a few criteria, but the three main criteria are:

LPN (licence plate number)
Month
Year

It prompts the user for each of these, which is great! But the information that is selected each time, only varies by the LPN field. For example.

The data for December has just been imported, John Smith decides he wants to select all data where Month=December, Year=2005 and LPN will equal that of the car ie: ABC123.

Is there a way I can get the query to look-up another table with the LPN's in it and then run the report query, automatically generating the reports for me (saving them as PDF and e-mailing them also would be AWESOME... but i think i'm dreaming there).

ie:

It will automatically put ABC123, DEF456, HJK789.... etc into the LPN field, as the Month and Year will remain the same.

Hi -

What do Month and Year represent--and incidentially, these are both reserved words in Access (the names of functions in this case) and as such shouldn't be used as field names--? If they are the expiration date of the LPN then what are you expecting as a result?

A little more info would be helpful.

Best wishes,

Bob

Month is the value of the month in name terms - January, February etc
Year is the value of the year in numbers - 2005, 2004, 2003 etc

The result is that it selects ALL information where the Month is equal to X and the Year is equal to Y. So for the above example, it will select all entires from November of 2005 that are from the LPN of ABC123.

So a typical entry in the table might be:

LPN: ABC123
Month: December
Year: 2005
Value: $4.00
Date: 12/12/2005
Time: 11:35pm

Does that help a little more?