[AccessD] Query does not return all records

In Access, under Tools | Options | Edit/Find, that is a parameter named,
"Don't display lists where more than this number of records read: ___."

The default is 1000 - perhaps changing to a larger number would help?

I've never modified this myself - good luck!
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Wednesday, January 12, 2011 11:08 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Query does not return all records

The following query only returns 1046 records even though the table
dbo_CompletionMaster has 2085 distinct records. What am I doing wrong?
Thanks.

SELECT dbo_DSS_CompletionMaster.PID, dbo_DSS_CompletionMaster.Well_Number,
Last(dbo_DSS_StatusChanges1.StatusDate) AS LastOfStatusDate
FROM dbo_DSS_StatusChanges1 RIGHT JOIN dbo_DSS_CompletionMaster ON
dbo_DSS_StatusChanges1.PID = dbo_DSS_CompletionMaster.PID
GROUP BY dbo_DSS_CompletionMaster.PID, dbo_DSS_CompletionMaster.Well_Number
HAVING (((Last(dbo_DSS_StatusChanges1.StatusDate))<#1/1/2001#));


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com