Query design Microsoft Access

I have a table called tblInvoicesSubmitted. I have a field named named DateSubmitted and a field named DateCheckRequested. It would also include a field named InvoiceID for identification purposes. I need a calculation, for Access, that will calculate the number of days inbetween these two fields (for example if it was 30 days). I want this calculation to show up in it's own field and then to be sorted by largest to smallest.
mmcgillo88Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
to calculate for the days difference, use datediff()

select invoiceid, [DateCheckRequested],[DateSubmitted], datediff("d",[DateCheckRequested],[DateSubmitted])
from yourTable
0
 
plummetCommented:
Yes, that's the solution, so in the query designer add a column with the following value as specified by Capricorn1:

datediff("d",[DateCheckRequested],[DateSubmitted])
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.