I have an Access 2010 database that I am using as a test to Store Historical Maintenance records for different pieces of machinery. I am looking at producing a report for each machine. I was looking at passing a parameter to the report for a particular machine which would then display all the records for that particular machine.
The database comprises 5 tables:
4 of the tables are for storing details of the service job to save the operator having to type them in each time -
tblElement - populated by frmNewElement form
tblMachine - populated by frmNewMachine form
tblTasks - populated by frmNewTasks form
The 5th Table - tblHistory - populated by the frmMaintenance form is the one that stores the records that I am trying to report from. I have set up qryHistory query which allows me to pass a date parameter to the MaintenanceHistoryByDate Report which works OK.
However, I have tried several ways to create a query that would allow me too pass a Machine name parameter to another report I have created - Maintenance Schedule but it either returns nothing or the debug screen launches.
I have attached the test database with 5 dummy records to view