running a query to compare 2 date fields

J

jaberwocky

Ok, my mind is drawing a blank. I have an ACCESS DB and a query tha
shows 2 date fields, say Date A and Date B. I want to create a quer
using criteria that will compare these 2 fields and then show an
record set where Date A is > Date B. Both my fields are in Date/Tim
datatype.

I cannot think of the expression i would use on the criteria line t
get this result...ughhh

Help anyone
 
M

MGFoster

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


You had part of the answer in your question.

SELECT DateA, DateB
FROM TableName
WHERE DateA > DateB

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQD1GWIechKqOuFEgEQJVJwCgzYjmC7aD9hl24GSZsulXLWR9t5oAoKu9
cVwcPzQCz0QntcCL7Hz8UUX/
=Lbwa
-----END PGP SIGNATURE-----
 
Top