conditional report total

H

Harry

Hi to all. I need to do a report total for records with fld1 = 'A' only. Records with fld1 other than 'A' are also printed but need not total it. Any suggestion?

Thanks in advance!
 
H

Harry

Just figured out, =sum(iif(condition, t,f))

----- Harry wrote: -----

Hi to all. I need to do a report total for records with fld1 = 'A' only. Records with fld1 other than 'A' are also printed but need not total it. Any suggestion?

Thanks in advance!
 

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

Incone & Expenses Statement 0
Group Totals and Grand Totals on each page 3
Consolidation Table from Different Excel Tabs with Different Format 1
A03 - count in report footer gives me #Error? 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Append table with If then else 2
Query Help 4
Report Group Footer DLookUp 0

Top