Two calculated fields in the same query are resulting in an "Enter Parameter Value"

[PinkDuster]

I created a query to calculate and summarize total line item cost, and total order cost by order for each customer.

SELECT tblCustomers.CustName, tblOrders.OrderID, tblOrders.OrderDate, Sum(tblOrderDetails.[Quantity]*[SoldAsPrice]) AS LineTotal, tblOrders.OrderShippingAmt, [LineTotal]+[OrderShippingAmt] AS OrderTotal
FROM (tblCustomers INNER JOIN tblOrders ON tblCustomers.CustID = tblOrders.LkupOrderCustID) INNER JOIN tblOrderDetails ON tblOrders.OrderID = tblOrderDetails.fkOrderID
GROUP BY tblCustomers.CustName, tblOrders.OrderID, tblOrders.OrderDate, tblOrders.OrderShippingAmt, [LineTotal]+[OrderShippingAmt]
ORDER BY tblOrders.OrderID;

When I run the query, I get the following error, but when I click OK, the query still runs, and the results are as expected. I have done the preliminary review of the expressions, but I can't find a problem.





PS., thank you to everyone who has pointed out that I can calculate totals in queries, rather than saving them to tables, I just need to get over this hurdle.

[ranman256]

you cannot create LINETOTAL field AND use it elsewhere in the same query.

Either make 2 queries:
Q1 creates LINETOTAL , then Q2 uses it
or
in your single query above, use the formula in every instance: Sum(tblOrderDetails.[Quantity]*[SoldAsPrice]) +ShippingOrder

[PinkDuster]

Thank you, I tried both approaches however could not make the single query work because of the aggregation constraints (summing various lines by Order number).

I used 2 queries, and get the correct results (with the Shipping Amount added to the sum of the lines).