Return to Website

MS Access

Computers at Large brings MS Access Forum for you to ask questions, answer questions or look up solutions

MS Access
Start a New Topic 
Author
Comment
Determining Date Intervals

Hi. If anyone can show me examples of how to do this, I would be very appreciative. I have a database table with two fields DATERECEIVED (into the shop) and MAILDATE (out of the shop). What expression could I use in my queries to determine: 1) the number of days between dates in each record, and 2) which records contain dates with intervals greater than, say, 3 days? Thanks again in advance.