I have a database that I was given to fix by my boss. I am having problems with my production report.
The person who made the queries used cross tab queries and then made forms out of each query. Took those forms and put them all on one form called ,"frmProductionReport.
What I need to do is add another field to each form that will total the models. So i added a field in the table called,"tblMODHistory" and put a field in there called,"Program Total" . I then added that field to one of the queries called,"qryTotalInstalls".
Now on my Production Report One of the forms that has Temple information is not showing up. How do I add a total field to each form?
Here is an example of what Im talking about
MOD KIT M2 M3 M7 Program Total
ASSS 1 4 2 7
AOA 2 3 5 10
Enclosed is my database.