Multiply constant by date range

T

Tommy2326

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
 
D

Dale Fye

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
 
T

Tommy2326

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