calculation based on query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written a query that displays start dates and completion dates for
jobs specific to one customer. I would then like to calculate the interval in
weeks in between the end of the last job and the start of the next, so that I
can draw a graph displaying this data.
How would I calculate the interval?
Thanks
 

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

DateDiff to calculate work days 2
Error when running Query 1
Calculating Time Difference 2
Combo Box Query Not Working 2
Extract information from Report into a graph/chart 3
elapsed time calculation 6
Complex Selection Criterion 2
Matching results from two queries 7

Back
Top