MS Access & ADO Query DateTime Field Joins
Posted on 2011-03-24
I have a MS Access DB containing 2 Tables CreditCard Charges and EmployeeCharges.
I am trying to match employee charges with bank credit card charges via two fields
amount and [tdate]. The Tdate field in both tables is a datetime field.
Using the following sql command both as an MS Access Query and as a Delphi ADO Query
misses records that are visiually present in both tables and should match.
This happens for apparently random records with no discernable, visual reason for them not to match. The same records fail for either approach.
I'm wondering if the field format has something to do with it( ie general vs short date, etc )
select * from [CreditCard Charges] a
LEFT OUTER JOIN
a.Amount=b.amount and a.tdate=b.tdate
Can anybody offer another way to do datetime field joins?