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
counting records 0
How to count records using count(*) in a chart report 3
Count In Group Footer 1
counting records shown in a report 3
Counting records in group not working - Access 2007/WinXP 4
Report Footer 4
Count of records where checkbox 1 is unchecked, checkbox 2 is chec 1

Top