unless you have duplicate values you can just do a count on the date field. it will exclude NULLs from the count.
Count(table.dischargedate)
If you have duplicate rows then you will need to do variable formulas, or a running total (RT).
I prefer Running Totals (many other prefer variable formulas).
The RT version is
Right click on Running Totals and select NEW
Name = DischargeCount (or whatever)
field to summarize= PK from the episode table where the discharge date is
type of summary=DistinctCount
evaluate=use a formula
NOT(isnull(table.dischargedate))
reset=Never (for a grand total)
place in report footer (RTs do not work in headers)
Edited by DBlank - 04 Apr 2012 at 7:53am
IP Logged
