sum or count with criteria

M

Michael Noblet

I have a calendar report that shows the length of time an
individual is in the ER for a given day. I open the
report via a popup window that filters the report by a
user entered date.

The report has columns for each hour of the day. I need
to have a total in the report foorter for each hour. my
dcount function is below:
=DCount("[arrival (first)
date]","rptVolumeSummaryHourly","[arrival (first) date]
< '01:00'")

I have tried several others but am not able to get both
the total and the filter to work together.

Any help would be appreciated.
 
D

Duane Hookom

Is this the same question as you ask in a more recent thread? If not, are
you comparing a date field/value with a time string?
 
Top