On May 12, 12:24=A0pm, "Ed Robichaud" <edrobich...@[EMAIL PROTECTED]
> wrote:
> I'm struggling to come up with a query/re****t of daily attendance for
> records that have only start and stop dates. =A0A x-tab (with parameters
t=
hat
> records be within a selected date range) =A0 would seem to be the way to
g=
o
> here, but how do I get a count for each date within that range?
>
> thanks -Ed
Create a calculated field in the query that determines if the date
falls between the start and stop dates, returning the number 1 if
true, and 0 if false, then sum those numbers.
isPresent: IIF([Enter Date]>=3D[Start] AND [Enter Date]<=3D[stop],1,0)
Q
|
