sum or count with criteria

  • Thread starter Thread starter Michael Noblet
  • Start date Start date
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.
 
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?
 
Back
Top