General discussion
June 10, 2002 at 11:46 PM
edmond_sng

Access/Excel query

by edmond_sng . Updated 24 years, 3 months ago

I am trying to run a Query on Access or create formula in Excel which will calculate Length of Time for Response:

Deadline: 01/04/02
Response: 05/04/02

Length of Time for response: 5 days

What criteria will I need to set in Access or if I analyze it with Excel – what formula would I use to calulate this? The format of the dates are set as above.

Thanks for your help. This will help me to write up a report.

This discussion is locked

All Comments