Creating report which pulls info from different queries/tables 1

[macleod21]

Hi everyone,
I am hoping someone will be able to assist me with this problem. I am trying to create a report which will pull chosen and pre-selected information from various queries/tables based on the user inputting an employee ID number. The purpose of this report is to provide an employee a synopsis of used and remaining paid and unpaid leaves, etc. I am able to run various reports for all employees which captures this info, but not one where I can select to run the info for one employee only.
I have tried to create a form/query independently with this info but I receive a blank screen or it defaults to only one employee member, and will not allow me to punch in a different employee code to access their respective info. Are or is there a max number of items I can include in this report? Is it possible to run a report that will capture this info from all of the identified locations at the user's discretion? Please if anyone can help it would be greatly appreciated as I have been baffled for well over a week!! Thanks in advance for your help.

 

[dhookom]

Have you been able to limit a report to a single employee? If not, create a new blank form and place a combo box on the form that selects the employeeID (or other primary key field). Name the form "frmSelectEmployee" and the combo box "cboEmployee".
You can then create a query of your tables and set the criteria under the employee ID field to:
Forms!frmSelectEmployee!cboEmployee
YOu can place multiple subreports on a single main report.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.