Query. Start date - End date = elapsed time in days and time..??? HOW?

[Timw]

Hi Guys,

I am very new to this so please break it down for me.

I have a query that returns all jobs on my helpdesk, but I want to
compare the Start Date and the End date and then output the elapsed
time in days and hours minutes? How do I do this?

The majority of jobs are closed but a few are open, will that cause
problems?

Many Thanks

Tim

 

[Allen Browne]

See Doug Steele's advanced DateDiff() at:
http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[Timw]

Thanks very much for pointing at the info. :¬)
Although I don't really know what to do with it, Do I cut and paste it
into my design view of the query I want to run?

Sorry to ask what must be painful questions for everyone here.

Thanks

Tim

 

[Allen Browne]

Yes. Click the Modules tab of the Database window.
Click New. Access opens a new module.
Paste the code in there.
Choose Compile on the Debug menu to ensure Access understands it.

You can then use it anywhere you can use one of the built-in functions, e.g.
in a query, or in the Control Source of a text box.

Thanks very much for pointing at the info. :¬)
Although I don't really know what to do with it, Do I cut and paste it
into my design view of the query I want to run?

Sorry to ask what must be painful questions for everyone here.

Thanks

Tim