Max Wanadoo
max.wanadoo at gmail.com
Sat Oct 3 08:17:21 CDT 2009
Hmm, you have confused me a bit here (easy done, eh?) When you run the sub are you putting the sql out to the IW with debug.print strSQL and then cut-n-pasting that into the QBE? Unless you do that you may find that you do not have EXACTLY the same query being run. Derby is fine, John. Up on the high grounds. We don't get much bad weather here really. All the rubbish that USA sends us via the Atlantic get dropped on Wales before it reaches us. All the rubbish that Scotland send us get dropped over YOUR area before it reaches us. The South only send good weather and nothing ever comes from the East. Well off, really. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Johncliviger at aol.com Sent: 03 October 2009 14:00 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Access 2002 SQL problem Hi Max Good to see your still on the ball. Hope your not flooded out down in the wet lands of Derby. When I run the Docmd.RunSQL the query produces 511 records when it should produce 48 records which it does thru QBE. It also works fine if I remove the 2nd AND ((tbl_PatientDetails.RecallFlag) = 0); I got to thinking that it must be the 2nd AND together with brackets in the wrong place. There is an Index on the table but its an Autonumber. Maybe I need format the SD and ED dates before they arrive in the Sub. To be continued...... regards johnc -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com