Counting Records in report footer

S

Sam

I am trying to count records in the report footer when a certain condition
exist when calculating the difference between two fields, ie ([field
1]-[field 2]) = 0. Only count the records that match the results. Any
suggestions?
 
C

Clifford Bass

Hi Sam,

Try something like: =Sum(IIf([field 1] = [field 2], 1, 0))

Clifford Bass
 
S

Sam

Thanks Cliff, the formula works fine and does exactly what I need.

Clifford Bass said:
Hi Sam,

Try something like: =Sum(IIf([field 1] = [field 2], 1, 0))

Clifford Bass

Sam said:
I am trying to count records in the report footer when a certain condition
exist when calculating the difference between two fields, ie ([field
1]-[field 2]) = 0. Only count the records that match the results. Any
suggestions?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A03 - count in report footer gives me #Error? 0
How to count records using count(*) in a chart report 3
Count In Group Footer 1
counting records shown in a report 3
Mail Merge skipping records/sending one at a time 0
Page numbering with Merged Document and IF statements 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help with Iif on Report 4

Top