Function / criteria to give me records from the last 90 minutes

I have a time/date field in my select query and I want to set the criteria to only return records from the last 90 minutes.开发者_开发技巧 What criteria should I use?

You'll want to use the DateDiff function to do the comparison. Something like:

... WHERE DateDiff("n", RecordDate, CurrentDate) <= 90 ...