G
Guest
Hi,
I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:
=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")
Can someone please show me the light?
I am trying to count the number of visits in a report. The field name is
[VisitType] and I have several types of visits recorded. My form displays all
visits and counts how many there are. I need to then count how many are "Ad
Hoc" visits, How many are "Investigations" and how many are "Flash" visits.
My code that does not work is as follows:
=Count([VisitType]="Flash")
or
=[VisitType].Count("Flash")
Can someone please show me the light?