Is it that your reports add the totals at the time the report is ran. Most of the time you don't save the total to a database and you do the calculation at run time only. if this is the case you will have to save the totals to a temp table or some thing first then export.
Hope it helps.
You can Try this John, add this code to the sub form open event.
I would probably make a pass-through form with something like this in the on_open event.
Private Sub Form_Open(Cancel As Integer)
If IsNull(DLookup("date", "tblsource", "date = #" & Date &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.