Caluclate no of days between date records

[Bruce]

I have a table with a date field tbl_Date.ImportDate.

If I have a select query that is sorted DESC by ImportDate I would like to
add a calculated field that shows the number of days between the records date
and the previous date.

How should I go about this?

Bruce

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/kb/210504/en-us