Sum of SQL Statement

[DS]

I need to get the Sum of Expr4 where Taxed is True.....How would I do
this? I need to pass it to a textbox on a form> This is the code of a
listbox that shows the current records, Expr4 being the price of the Item.
Any help appreciated.
Thanks
DS

Private Sub Form_Current()
With Me.ListOrders
..RowSource = "SELECT SalesDetails.SalesID, SalesDetails.LineID,
SalesDetails.Quantity, Items.ItemName,
CCur(IIf([Expr3]>0,[Expr1]-[Expr3],[Expr2])) AS Expr4, Items.ItemType,
SalesDetails.Sent,
CCur(Choose([PriceLevel],[Price1],[Price2],[Price3],[Price4],[Price5],[Price6],[Price7])*[Quantity])
AS Expr1, SalesDetails.MenuNum, Items.Taxed, Items.Inclusive,
Items.NoTax, CCur(Nz([Expr1]-[DiscountAmount],[Expr1])) AS Expr2,
CCur(Nz([Expr1]*[DiscountPercent],0)) AS Expr3 " & _
"FROM Items INNER JOIN ((DiscountTypes RIGHT JOIN SalesDetails ON
DiscountTypes.DiscountID = SalesDetails.DiscountType) LEFT JOIN Menus ON
SalesDetails.MenuNum = Menus.MenuID) ON Items.ItemID =
SalesDetails.ItemID " & _
"WHERE (((SalesDetails.SalesID) = [Forms]![CheckPreview]![SalesID]))" & _
"ORDER BY SalesDetails.LineID, Items.ItemName, Items.ItemType;"
..Requery
End With
End Sub

 

[John Vinson]

I need to get the Sum of Expr4 where Taxed is True.....How would I do
this? I need to pass it to a textbox on a form> This is the code of a
listbox that shows the current records, Expr4 being the price of the Item.
Any help appreciated.
Thanks
DS

Your query doesn't CONTAIN an Expr4... I'm confused.

Try

Sum(IIF([Taxed], [PriceOfItem], 0))


John W. Vinson[MVP]