Comparing dates and filtering in a query!, Please help!!

[ubamonkey]

Hi Guys,
I'm trying to write a query that will compare two preset dates (From a previous table), and only display dates which have a gap of 24hrs between them.
I can't get DateDiff to work as it just stops any records from appearing.

I've also tried using standard formulae i.e. Greater than, Less than. But how do you get the program to say "If greater than 24hrs, don't display those records".

if you could e-mail me at geniusbreed@yahoo.com, or leave a solution I would be grateful for all eternity!!!!

CHeerz

 

[Tommy B]

If you have the field that shows datedif, why not create a new field called say difference with an iif statement.

This might work:

Difference: IIF([DateDif]<=24,"Y","N") then in the criteria element put Y.

Hope this helps,

Tom.