count of non numerial field

G

Guest

I want to count the number of In patients and Out patients in my report. I
can get a total of entries but can not total of in and total of out. This
="Summary for " & " 'In patients' = " & " " & [strinpatients] & " (" &
Count(*) & " " & IIf(Count(*)=1,"detail record","detail records").
is the expression I am using. Any help.
steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count a field 14
Totals On a report 3
Restricting counts with WHERE clause in report 2
Show total number of a group in another group header 5
Calculate report footer 2
Check boxes? 1
Access 07 Report - Need to Count lines in a Group 40
Count of Patients by City within date range 1

Top