Link to home
Start Free TrialLog in
Avatar of gigifarrow
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
Avatar of Flyster
Flyster
Flag of United States of America image

See if this is what you were looking for. I made queries that total each mod and then added them to the crosstab queries

Flyster
MODS-10-Apr-12v2a.accdb
Avatar of gigifarrow
gigifarrow

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"
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
Thank you for getting back with me could you please tell me what you did to make it work?
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial