count of non numerial field

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Back
Top