Hello~
I have a table record No, Day, Supplier, Item, UnitPrice, Quantity, Tax and TotalPrice. EX: Supplier_1 Item_1 @12*1-$12 Tax-$0
Then, I use this table make a query. In this query, supplier, Item, UnitPrice, Quantity and Tax are combined to Summary.
But Tax is 0 sometimes. I hope Tax-$0 is not shown in the result when Tax is 0. EX: Supplier_1 Item_1 @12*1-$12
I try to use this:
But it's error. How can I edit it?
My test file: https://reurl.cc/52880q
Thanks in advance.
I have a table record No, Day, Supplier, Item, UnitPrice, Quantity, Tax and TotalPrice. EX: Supplier_1 Item_1 @12*1-$12 Tax-$0
Then, I use this table make a query. In this query, supplier, Item, UnitPrice, Quantity and Tax are combined to Summary.
Code:
Summary: [Supplier] & " " & [Item] & " @" & [UnitPrice] & "*" & [Quantity] & "-$" & Round([UnitPrice]*[Quantity],0) & " Tax-$" & [Tax]
But Tax is 0 sometimes. I hope Tax-$0 is not shown in the result when Tax is 0. EX: Supplier_1 Item_1 @12*1-$12
I try to use this:
Code:
IF [Tax]>0 THEN [Supplier] & " " & [Item] & " @" & [UnitPrice] & "*" & [Quantity] & "-$" & Round([UnitPrice]*[Quantity],0) & " Tax-$" & [Tax] ELSE [Supplier] & " " & [Item] & " @" & [UnitPrice] & "*" & [Quantity] & "-$" & Round([UnitPrice]*[Quantity],0) END IF
My test file: https://reurl.cc/52880q
Thanks in advance.