Caculating totals from expression

[SteveGr]

Calculating totals from expression

Hi all,

I have a query that calculates the total number of books run on a printing press from a table. I type in the job ID number and it calculates:

NetCount: Sum([Gross]-[RunWasteImps])

This works fine but it gives me totals for different days that this job ran on a press. I want the total for "all" NetCounts for that job ID number.

Thanks, Stevegr

 

[pdx_man]

Remove the 'Days' field from the query.

 

[SteveGr]

Already tried that with no change to the output.
I am still geting duplicate records with different net counts. I think it is based on a per shift basis but shifts are not a field in my query.

 

[Jack Cowley]

If your query is based on two or more tables be sure that your joins are correct. If only one table then I assume you are using a Totals query so you will need to delete the offending field(s) that are causing groupings you do not want.

hth,
Jack

 

[Shawny]

I'm a very junior member with something that might help.
I recently had a similar problem.
I solved it by useing multiple queries, doing one calculation at a time in each query and baseing the next query on that one. I focused first on getting the math right. No info was used that was not needed to get the math. When I got a query where the math was right, I made the final query, and put in all the rest of the info I needed in it.
This seems like a silly waste of time, but I needed criteria based on the outcome of the math. I could not do it all in one query.
Hope I haven't confused ya.
Shawny

 

[SteveGr]

Thanks for all your help.
Stevegr