Counting in Reports

[laureneparker]

I am trying to count in a report. I have four columns that I am working with. These four columns are lookup columns so therefore they have a specific value. I want to be able to count when columns A, B, C, and D are certain values. HELP!! Any suggestions are appreciated.

Or can someone please give me a way to create a table to do this same function?

 

[spasticus]

what do you want to count? the number of records where A, B, C, D are a specific value?

 

[wackyd]

The OnPrint() event of the Detail section executes on each record and therefore can be used to increment some value based on your criteria.

If you aren't concerned with preserving the data and only want to count all distinct combinations of A,B,C,D then the aggregate function count() could be used in a query that is the source of your report.

 

[RuralGuy]

You can also use hidden textboxes with IIF<condition>,1,0) in their ControlSources and RunningSum set to something other than NO. Then just print out the hidden textbox in the footer.