gigifarrow
asked on
Queries are not working
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.
MODS-10-Apr-12v2.accdb
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".
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.
MODS-10-Apr-12v2.accdb
ASKER
It is working except the temple one has nothing in it. It is blank there is no information at all showing up.
There's no information because in the qryTotalInstallsTemple criteria, you have "Temple, TX". In your table it's "Temple, PA"
ASKER
I am now getting information but under M3 and M7 im getting an error #name and no mod kits are showing up.
Sorry for the delay, it took me a while to figure out the force column issue. This one should work.
MODS-10-Apr-12v2a.accdb
MODS-10-Apr-12v2a.accdb
ASKER
Thank you for getting back with me could you please tell me what you did to make it work?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Flyster
MODS-10-Apr-12v2a.accdb