Nancy Therrien
asked on
MS Access double total when printing
Good afternoon,
I have a problem in the fact that in my BDAccess I have a report create that sum the amount of time.
This is working fine when I see the report on screen, but when I hit print after it has been look as preview, the Total hours have been double. The rest of the report is still good, just the total. If I asked it to print without preview, the total is good.
I have searched a couple of days the reason why but I don't find anything.
Maybe you can help me please.
Thanks
code-print-total.txt
I have a problem in the fact that in my BDAccess I have a report create that sum the amount of time.
This is working fine when I see the report on screen, but when I hit print after it has been look as preview, the Total hours have been double. The rest of the report is still good, just the total. If I asked it to print without preview, the total is good.
I have searched a couple of days the reason why but I don't find anything.
Maybe you can help me please.
Thanks
code-print-total.txt
ASKER
hello PatHartman,
how do I reset the accumulator ?
The reason I'm doing it by code is that I have to separate mill from office hours and some hours are taken in R et D and some not.
Thanks,
how do I reset the accumulator ?
The reason I'm doing it by code is that I have to separate mill from office hours and some hours are taken in R et D and some not.
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh ! my god you are too good. Thanks I have putted in header print event the txt=0 and it is working.
Thanks a lot.
Nancy
Thanks a lot.
Nancy
ASKER
thanks for fast reply. solution is working just great !
Glad it worked for you. Been there, done that. But I remembered the solution:)
Is there some reason you are using code rather than functions to sum the hours. In the section/report footer, you can add a control with the following control source to sum the data.
=Sum(yourhoursfield)