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,