SUMIF In Report

#1 (**permalink**) 28-Jul-2006, 08:00 AM

Can you do a sum if in a Access Report? If so can someone give me an example
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9215-sumif-in-report.html
of how do do one. Basically I have three columns in a report that can so the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9215
value "Yes", "No" and "N/A". In a fourth column I have a numeric value. In
the report I want to show the sum of the yes's, no's and N/A's.

Thank you

*

#2 (**permalink**) 28-Jul-2006, 08:01 AM

Hi Lance,

here is an example for the first one:

Name --> SumYes
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9215
ControlSource --> =SUM(IIF(nz(Column1_controlname) = "Yes",
column4_controlname, 0))

Warm Regards,
Crystal
MVP Microsoft Access
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9215

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day

LanceMSU wrote:
> Can you do a sum if in a Access Report? If so can someone give me an example
> of how do do one. Basically I have three columns in a report that can so the
> value "Yes", "No" and "N/A". In a fourth column I have a numeric value. In
> the report I want to show the sum of the yes's, no's and N/A's.
>
> Thank you