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

  • Thread starter Thread starter Timw
  • Start date Start date
T

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
 
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
 
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
 
Back
Top