|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 26th, 2009, 01:15 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Report Filter Question
Hello!
I have tblEmployee with 400 employees and a tblDepartment with 20 departments. What is the best way to set it up so that I can print a report of ALL employees and their associated department (no filter) and then have the user select (via a dropdown) the department that they want to see a report on. I was thinking that a button on my Report Switchboard form opens another form with just a combobox tied to tblDepartment, and then that combobox supplies the filter for the report... I currently have one query with 20 reports and that seems crazy. And 20 queries with one report doesn't seem right either. So there has to be a way to do one query, one report, and then some intermediate user thing. ?? VR/Lost 
|
| Thread Tools | |
| Display Modes | |
|
|
Threaded Mode