query between 2 dates for total days between

K

koko

I need to write a query to find out the total number of days between two
dates. I don't know if my mind has just gone blank or what. But I can not
think of how to do it.
 
T

Tom Ellison

Dear Koko:

You could use the DateDiff() function. Information in "help" contains all
the details.

There may be more to it than that, but you don't give sufficient details to
begin to guess at that.

Tom Ellison
 
K

koko

Thanks Tom will try that and get back to you.

Tom Ellison said:
Dear Koko:

You could use the DateDiff() function. Information in "help" contains all
the details.

There may be more to it than that, but you don't give sufficient details to
begin to guess at that.

Tom Ellison
Click to expand...
 

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

Creating a Search using a combo box and then creating a report. 4
# of days between two dates 4
Enumerate the Days (all the days) Between Two Dates (?) 1
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Total appointments per agent 2
How to use/create code in MS Word to calculate age? 0
Finding record between two Dates Queries 2
Total number of days 1

Top