UtterAccess Discussion Forums > If then statement needed for Access Report

Full Version: If then statement needed for Access Report

UtterAccess Discussion Forums > Microsoft® Access > Access Reports

edfafc

Nov 27 2007, 05:40 AM

Hello all,

I am running a report with two specific columns that I need to calculate.

The first column is called District and it will have a value of either 1 or 3.
The second column will be AmountPaid and it is set for currency.

I am trying to get my report to calculate out the sums for each district.
if District = 1 then sum(amountpaid)
if District = 3 then sum(amountpaid)

Any suggestions?
Thanks

Larry Larsen

Nov 27 2007, 05:53 AM

HI
Try this in an unbound control..
Control Source..
=Sum(IIf([District]=1,[AmountPaid],0))

edfafc

Nov 27 2007, 06:20 AM

That works great!
Thank you very much for your help.

Larry Larsen

Nov 27 2007, 07:56 AM

Hi
You're welcome..

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.