I have two queries below that give me Number of Unique days from a date
range and number of gauges calibrated in that same date range. The totals
are skewed however due to the fact that the date range is covering 7 days
per week when in fact the work week is only 4 days, Monday-Thursday. I
somehow need to factor in this work week of 4 days. Does anyone have
any suggestions as to how I can accomplish this?
range and number of gauges calibrated in that same date range. The totals
are skewed however due to the fact that the date range is covering 7 days
per week when in fact the work week is only 4 days, Monday-Thursday. I
somehow need to factor in this work week of 4 days. Does anyone have
any suggestions as to how I can accomplish this?
Code:
SELECT Sum(IIf(([Date Due] Is Not Null),1,0)) AS Gages
FROM [All gages]
WHERE ((([All gages].[DATE DUE]) Between [Forms]![DateRangeQueryForm]!
[StartDateTxt] And [Forms]![DateRangeQueryForm]![EndDateTxt]));
Code:
SELECT Count(UniqueDaysAll.[DATE DUE]) AS [CountOfDATE DUE]
FROM UniqueDaysAll;