can this group help out the gent below? I will forward your reply to the group
to him
his field name is [status] and it has listed as values in it either a C, R, U
________________________________
From: Derek Hess
Sent: Wed 10/24/2007 10:16 AM
To: Dave Moreau
Subject: RE: 0718 AM
Sure, I can try. Here goes.
In the report header we have a text box. Within that text box we would like to
have an expression that counts records from within the report below, that
equals a particular letter (value) in a specific column. For example:
The column in question has letters ('C', 'R', 'U', etc)
When the value within that column is an 'R' we would like to have the count
displayed, so of lets say 400 records, if 36 have 'R' in that column, the
textbox should display 36 not 0 or 400.
Is this clear enough??
-Derek
<http://www.cafemessenger.com/info/info_sweetstuff2.html?ocid=TXT_TAGLM_OctWLtagline>
This e-mail and any attachments may be confidential or legally privileged.