I have a select statement that returns the right record when it runs in the Access query wizard, but returns too many records when run in VBA code.
This is the query:
Select * From Data_detail Where ( Procedure = 'T1004') AND (Charges = 139.5) AND (cdate(To_Date) = '8/10/2009') AND (parent_ID...