Search results

Im trying to create a daily query which shows all the orders that have been put into that system that day. Its shows all the orders (order id, quantity, price, items). But i had to create multiple queries because of different calculations. I hve tried everything else it wont work. This is the...

i used 3 queries to build a report, but it seems to have duplicate data

But its an iff statement

it says this now

Heres the code SELECT Orders.[Order ID], Sum([Daily Query].[Total Cost]) AS OrderTotal, IIf([Order].[Delivery?]=Yes,[OrderTotal]+1.5,[OrderTotal]) AS Delivery FROM [Daily Query] INNER JOIN Orders ON [Daily Query].[Order ID] = Orders.[Order ID] GROUP BY Orders.[Order ID];

Im not sure what you mean, this error shows up

Can someone please help me with this error. When i try to select the query that [Delivery?] is from it wont work. It gives the SQL error. What code should i write in SQL to fix this error.