-----Original Message-----
Really new at this cannot figure out how to count
specific records in a record set. if I have 100 records
in a report I can use the count(*) to count the 100
records but if I have a field that i want to count the
number of records out of the 100 that contain a certain
value...this is what i am having problems with..
If you need to count only how many times a specific value occurs in your report,
you can use the "Sum()" function to do that:
=Abs(Sum([FieldName]="SomeValue"))
The "=" expression will generate a "True/False" value, which evaluates to
either -1 or 0, so the Sum() will reflect the total of "True" values as a
negative number. The "Abs()" function will convert that number to a positive
number. Use this technique as the "Control Source" for a text box for each value
you want a count for.
