If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Count" expression in report
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 |
#2
|
|||
|
|||
"Count" expression in report
On Wed, 27 Feb 2008 09:31:04 -0800, Trying wrote:
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/Ap****ueBadWord.html To answer your question.... =Sum(IIf([TypeField] = "Truck",1,0) -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|