Wrong Calculations

[Jrmrcol]

Hi, I have an ODBC connection. I created a few queries and a few
reports, but I have noticed that in a report the footer calculations
are different all the time, knowing that they should be the same. Does
anyone know why this is happening and how to correct it?

Thank you,

 

[Jeff Boyce]

We aren't there. We can't see what you are doing.

Please post the SQL statement for the query you use to feed the report.
Also, if you are using expressions to do the "footer calculations", please
post those as well.

By the way, I can't tell from your description whether the results are
different because your query is returning different values, or are different
each time you run the report ON THE EXACT SAME data.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jrmrcol]

Here are the properties about the query I having problems with.

Query: Qry_AR_InvTotals_By_Periods_07 Page: 1
Properties
Date Created: 1/10/2008 2:28:04 PM DOL: Long binary data
GUID: Long binary data Last Updated: 1/21/2008 1:07:46 PM
MaxRecords: 0 ODBCTimeout: 60
OrderByOn: False Orientation: 0
RecordLocks: No Locks RecordsAffected: 0
RecordsetType: Dynaset ReturnsRecords: True
Type: 0 Updatable: True
SQL
SELECT reccln_07.usrdf1 AS Jobsite, reccln_07.usrdf2 AS Super,
Sum(acrinv_07.invttl) AS SumOfinvttl,
acrinv_07.actper, acrinv_07.status, reccln_07.clntyp
FROM (actrec_07 LEFT JOIN acrinv_07 ON actrec_07.recnum =
acrinv_07.jobnum) LEFT JOIN reccln_07 ON
actrec_07.clnnum = reccln_07.recnum
WHERE (((reccln_07.usrdf1)<>"") AND ((acrinv_07.status)<>5) AND
((acrinv_07.actper)>0))
GROUP BY reccln_07.usrdf1, reccln_07.usrdf2, acrinv_07.actper,
acrinv_07.status, reccln_07.clntyp;


These tables are from the Accounting Management software! Every time a
run this query I have different values and a different number of rows,
it should not be that way because 2007 is closed year no one is
affecting the data anymore. My database is connected throught ODBC
using FoxPro ODBC Driver.

Thank you,

 

[Jeff Boyce]

I'm not spotting anything right off.

Have you tried starting from scratch and creating a new query that returns
only one piece, then building up to the full query you need?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Jrmrcol]

Thank you for taking you time in helping me out. Right know I'am
trying to see if there is any other way to have this done!