Caluclate no of days between date records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with finding unmatched data 4
Dcount returning no results!!! 0
Query for previous field value 3
Help selecting an additional field in my query 3
Compare dates in two seperate records 7
To calculate number of working days between 2 dates 4
query on date 1
Complex Analytical Query help please 2

Back
Top