Multiply constant by date range

G

Guest

I'm trying to create a query that will show you data from a selected date
range. The data to be shown is available time, running time and downtime.
The running time and downtime are taken from other queries and are being
dislpayed ok. My problem is the available time. The daily time available is
84 hours (12 hours per shift x 7 machines), how can I multiply the daily time
by the number of days in the selected date range?

Thanks for the help

Tommy
 
G

Guest

Tommy,

Take a look at the CalcWorkDays function in the Calculate Work Dates thread
of this newsgroup (dated 9/13/07). It computes the number of workdays
between two dates, which could then be used as your multiplier in your query.

HTH
Dale
 
G

Guest

I looked at that function, where would i put that when using it, in the
expression builder??
 

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

Calculating the sum of a field 2
Combine multiple tables with different date ranges 2
Select Date For Query 2
CREATE TOP 5 LIST PER DATE 1
Number of days 9
Date parameters in a query 3
how do i? 7
Validation Rule 6

Top