Count of Dates For Non-Unique Values

[PWD]

Good morning, I have a report where I want to count the number of patients who are discharged in a week. When I just entered

Count([Discharge Date])

it appeared only to count the unique values.

I could get the correct number by using

Count([Discharge Date Time])

but I suppose there is still the possibilty of more than one patient in more than one area being discharged in the same minute (seconds aren't recorded). So is there a way to do this without having to create a variable for each record where the patient has been discharged, or would that be the best course of action?

Many thanks,
D€$

 

[SkipVought]

Hi,

How about counting the....

....Patients?

 

[PWD]

Hi Skip, I'm looking at a similar report now and I've just seen that there's an unique hospital spell identifier - this will work even if it's the same local patient ID.

It's good to talk. Cheers!

Many thanks,
D€$