If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum in a report not giving the correct answer
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. -- Jeff G Maintenance Tech Milgard Tempering |
#2
|
|||
|
|||
Sum in a report not giving the correct answer
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" wrote: 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. -- Jeff G Maintenance Tech Milgard Tempering |
#3
|
|||
|
|||
Sum in a report not giving the correct answer
See, I knew it was going to be stupid simple!!! Thank You Very Much
-- Jeff G Maintenance Tech Milgard Tempering "Duane Hookom" wrote: 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" wrote: 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. -- Jeff G Maintenance Tech Milgard Tempering |
Thread Tools | |
Display Modes | |
|
|