Totals On a report

[Eric]

I added a field on a report footer that is suppose to count the number of
patients on the report, this is what I added but it does not work.
=Count([Patient])
Instead of getting a count of patients I get an #Error. Any suggestions as
to why that is happening and what I can do to fix it?
Thank you,
Ericd

 

[DrewJam71]

Eric:
Try =count(*) instead. Best of luck!!!

 

[Eric]

Well, I tried that and I still get the #Error instead of the count. Is it
possible this feature is not installed? I know some of the add on feature
were not installed.

Eric:
Try =count(*) instead. Best of luck!!!

I added a field on a report footer that is suppose to count the number of
patients on the report, this is what I added but it does not work.
=Count([Patient])
Instead of getting a count of patients I get an #Error. Any suggestions as
to why that is happening and what I can do to fix it?
Thank you,
Ericd

 

[DrewJam71]

Hush!!! What version of Access are you using? You normally get this type of
error when there are no records listed in the report. Did you actually see a
listing of the patients when you preview the report?

Well, I tried that and I still get the #Error instead of the count. Is it
possible this feature is not installed? I know some of the add on feature
were not installed.

Eric:
Try =count(*) instead. Best of luck!!!

I added a field on a report footer that is suppose to count the number of
patients on the report, this is what I added but it does not work.
=Count([Patient])
Instead of getting a count of patients I get an #Error. Any suggestions as
to why that is happening and what I can do to fix it?
Thank you,
Ericd