Re: Wrong Calculations

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,


.

Relevant Pages

  • Query Process not showing users when not Admin
    ... Firstly apologies if you've read this in similar newsgroups - I've got nowhere ... with it and perhaps someone in here won't have seen my query before... ... I'm writing a simple script that a user can run to show them how many ... As super it comes out like this: ...
    (microsoft.public.windows.server.security)
  • RE: rename a Web application
    ... \par It is an expected behavior that the old url still works. ... \par Regarding your query, you can consider creating a new web application with the new name and then attach the old content database to the newly created web application. ... \par When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Wrong Calculations
    ... Have you tried starting from scratch and creating a new query that returns ... Microsoft Office/Access MVP ... RecordLocks: No Locks RecordsAffected: 0 ... My database is connected throught ODBC ...
    (microsoft.public.access.macros)
  • select count (distinct X, Y)
    ... I'm trying to make this query: ... select count (distinct UC_CODE, SYNT, SUPER) ... WHERE HYPER IS NULL ... AND SUPER IS NOT NULL ...
    (microsoft.public.sqlserver.mseq)