Different Totals, Different computers

[emtenzer]

I am running a DAO recordset in a report. There is a total in the report footer using Sum - Over All. The references on both computers include DAO 3.6 Object Library. On one computer the totals are correct, on the other, it simply picks up the value of one of the items. What could cause this?

 

[dhookom]

Can you explain why/how you are using a DAO recordset in a report? What does a recordset have to do with a running sum? What are the control sources and names of significant controls?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[emtenzer]

Here is my code behind the report - on open:
Dim intX As Integer
Dim qdf As QueryDef


' Set database variable to current database.
Set dbsReport = CurrentDb()

' Open QueryDef.
Set qdf = dbsReport.QueryDefs("tblPromoComparison_Crosstab")
' Set parameters for query based on values entered in PayablesCrossDialogBox form.

' Open Recordset.
Set rstReport = qdf.OpenRecordset()

' Set a variable to hold number of columns in crosstab query.
intColumnCount = rstReport.Fields.Count

 

[dhookom]

You kinda answered one of my questions [blue]"Can you explain why/how you are using a DAO recordset in a report? What does a recordset have to do with a running sum? What are the control sources and names of significant controls?"[/blue]

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[emtenzer]

This report is basically a crosstab report that changes it's headings and row columns accordingly. It is based on a comparison of sales between 2 time periods or two different "promotions". The report footer is simply a text box equal to the "detail" with a running sum over all. Like I said before, on my computer - xp pro, access 2003, it is perfect. On my customer's, it simply picks up the number from the first item being totaled.

 

[dhookom]

I can't imagine what is happening with your file other than some issue with different service packs or versions.

I never create crosstab reports with recordsets like you have indicated. I have several sample crosstabs at a previous employer's web site

http://www.invisibleinc.com/divFiles.cfm?divDivID=4.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.