Summing Given A Criteria

[Guest]

Is there a way to create a report or a query that will sum the values in the
field named "A" if the value in the field named "B" is Principal ?

Kind of like the "SUMIF" function in Excel.

Thank you in advance.

 

[Douglas J. Steele]

Create a query with an IIf statement in it:

IIf( = "Principal", [A], 0)

Sum on that statement.

 

[Guest]

Thank you. How do I "Sum on that statement" ?

Create a query with an IIf statement in it:

IIf( = "Principal", [A], 0)

Sum on that statement.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Is there a way to create a report or a query that will sum the values in
the
field named "A" if the value in the field named "B" is Principal ?

Kind of like the "SUMIF" function in Excel.

Thank you in advance.

 

[CompGeek78]

Thank you. How do I "Sum on that statement" ?

Turn on grouping in the query, then in the Total row under that
calculation, choose Sum.

 

[Guest]

Thank you. I am an Access novice. Can you show my the actual SQL to do this ?
Thanks.

 

[Douglas J. Steele]

Normally Access novices don't want to see SQL!

Try:

SELECT Sum(IIf( = "Principal", [A], 0)) AS TotalAmount
FROM MyTable