Sum in a report not giving the correct answer

J

Jeff G

I’m pretty sure this is a simple solution, I just can’t see it!!!

What I have is a data base that is tracking out technician daily time. It’s
fairly simple; I have two categories per technician; “Machine Down Time†and
“Shop Timeâ€.

I made a query using the simple query wizard s it will only show a running
total on a monthly basis.

I made the report also using the wizard. I grouped the results by “Monthâ€
and then by “Technicianâ€. I then asked the wizard to Sum the “Machine Down
Time†and the “Shop Time†and I also check the summery only box because on
this report we do not need a breakdown of all the entries.

So far, everything is working great!!!! I get a report that shows the
current month, the Technician’s name and their sum of “Machine Down Time†and
“Shop Timeâ€.

My problem is this: In order to have a complete report I also need to sum
the total of both “Machine Down Time†and “Shop Timeâ€. For example: (What I
currently have)

October 29, 2007
Technician John G.

Sum Machine Down Time
Shop Time

100 2300

Both times add up to 2400 (by the way everything is in minutes) which is the
amount in minutes in a work week (40hrs X 60min).

What I want to see is:

October 29, 2007
Technician John G.

Sum Machine Down Time Shop Time
100 2300
Total 2400

I tried to add a Text Box and set the control properties expression to:

=Sum([Machine Down Time])+{[Shop Time]) But I get a wrong answer! I still
believe that 2+2=4 so I must be missing something.

Any help or suggestions? Please be gentle with me, I don’t speak SQL. Thanks
for all your help.
 
D

Duane Hookom

I'm not sure where you got:
=Sum([Machine Down Time])+{[Shop Time])
Try
=Sum([Machine Down Time])+Sum([Shop Time])

This should work in Report or Group Headers or Footers.
BTW: You provided a lot of good information but never stated what the "wrong
answer" was.
 
J

Jeff G

See, I knew it was going to be stupid simple!!! Thank You Very Much :)

--
Jeff G
Maintenance Tech
Milgard Tempering


Duane Hookom said:
I'm not sure where you got:
=Sum([Machine Down Time])+{[Shop Time])
Try
=Sum([Machine Down Time])+Sum([Shop Time])

This should work in Report or Group Headers or Footers.
BTW: You provided a lot of good information but never stated what the "wrong
answer" was.

--
Duane Hookom
Microsoft Access MVP


Jeff G said:
I’m pretty sure this is a simple solution, I just can’t see it!!!

What I have is a data base that is tracking out technician daily time. It’s
fairly simple; I have two categories per technician; “Machine Down Time†and
“Shop Timeâ€.

I made a query using the simple query wizard s it will only show a running
total on a monthly basis.

I made the report also using the wizard. I grouped the results by “Monthâ€
and then by “Technicianâ€. I then asked the wizard to Sum the “Machine Down
Time†and the “Shop Time†and I also check the summery only box because on
this report we do not need a breakdown of all the entries.

So far, everything is working great!!!! I get a report that shows the
current month, the Technician’s name and their sum of “Machine Down Time†and
“Shop Timeâ€.

My problem is this: In order to have a complete report I also need to sum
the total of both “Machine Down Time†and “Shop Timeâ€. For example: (What I
currently have)

October 29, 2007
Technician John G.

Sum Machine Down Time
Shop Time

100 2300

Both times add up to 2400 (by the way everything is in minutes) which is the
amount in minutes in a work week (40hrs X 60min).

What I want to see is:

October 29, 2007
Technician John G.

Sum Machine Down Time Shop Time
100 2300
Total 2400

I tried to add a Text Box and set the control properties expression to:

=Sum([Machine Down Time])+{[Shop Time]) But I get a wrong answer! I still
believe that 2+2=4 so I must be missing something.

Any help or suggestions? Please be gentle with me, I don’t speak SQL. Thanks
for all your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top