Conditional Sum Function

[samthomasny]

Can someone please tell me what is wrong with this formula

Usage: IIf(([GTORSH]![PITEM]=[tbl_Inventory]![Item#]) And ([GTORSH]![PSHPDT]>=[BeginDate]) And ([GTORSH]![PSHPDT]<=[EndDate]),Sum([GTORSH]![PSHQTY]),0)

[BeginDate] And [EndDate] will be entered as parameter values when the query runs.

 

[Trevor G]

Welcome to the Forum,

Are you expecting to get a SUM from a list of data once you run the IIF Expression?

It may assist you to try running part of the IIF first and then look to use a second query to sum the data by using Total Groups