running a query to compare 2 date fields

  • Thread starter Thread starter jaberwocky
  • Start date Start date
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
 
Ok, my mind is drawing a blank. I have an ACCESS DB and a query that
shows 2 date fields, say Date A and Date B. I want to create a query
using criteria that will compare these 2 fields and then show any
record set where Date A is > Date B. Both my fields are in Date/Time
datatype.

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

ummm... you already did. Four lines up.

Put a criterion on DateA of
[DateB]
Click to expand...

And I can recommend the Sumatra Mandheling coffee, very smooth but
lots of caffeine... <g>
 
Back
Top