"Count" expression in report

[Trying]

Hi
I have a field, named [Type].
In a report, what is the expression to count this field “[Type]†where
Type=Truck
??? =Count([Type]) where type = “Truckâ€
Thanks

 

[fredg]

Hi
I have a field, named [Type].
In a report, what is the expression to count this field ´[Type]¡ where
Type=Truck
??? =Count([Type]) where type = ´Truck¡
Thanks

I would strongly suggest that you not use the word 'Type' as a field
name. Type is a reserved Access keyword and refers to an Access Field
property. For more information see:
http://www.allenbrowne.com/AppIssueBadWord.html

To answer your question....
=Sum(IIf([TypeField] = "Truck",1,0)