Thanks, I'm familiar with the DateDiff function, but what I would really
like is a method to calculate the # of folks present for each day within a
user selected date range.
The date-filtered query now returns records with:
ID, startdate, stopdate, etc.
i.e. 001; 3/2/08; 3/20/08;...
002; 3/1/08; 3/18/08;...
003; 03/15/08;3/20/08;...
For example, I can find how many folks were present sometime within
3/1/08-3/31-08, but I'd like a daily count of those present for:
3/1/08
3/2/08
3/308
....
3/31/08
-Ed
"Pachydermitis" <praesagus@[EMAIL PROTECTED]
> wrote in message
news:fc2d239e-7388-47b1-9150-d75541669337@[EMAIL PROTECTED]
May 12, 9:24 am, "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. A x-tab (with parameters
that
> records be within a selected date range) would seem to be the way to go
> here, but how do I get a count for each date within that range?
>
> thanks -Ed
Try using datediff in the query field.
Without seeing an example of your table I cn't be sure, but you might
put a conditional (datediff('d',FieldDate,date())=1) then sum instead
of count
P
|
