I am writing a report with Access 2003, but having some issues with the proper way to put the iff statement in the control source.

What I need to show in the text box is the sum of 3 tables but only if the customerid =1. Currently this is what is listed in the control source.

=IIf(([CustomerID]="1"),([documents]+[addl_pages]+[wasted_paper]),0)

It only brings back 1 result. Not all the sum based on the date.

Bascially, what I need is my report to sum (by date) all the totals but only if the customerid is 1.

Thanks!

Matt