Need Help With Total

[zacharyjunior]

I built a query that looks up all customer complaints from a certain time frame. It pulls from an invoice table and a order table. In the query I want it to calculate a total $ spent. Here is what I have so far but it does not work.

The following fields are from the order table.

Standard Cost
Quantity

The following fields are from the invoice table.

Parts
Labor
Misc

I tried to build in the query a statement.

StandardCost*Quantity+Parts+Labor+Misc

I wanted this to give me the total.

Any thoughts?

 

[Jerry Stoner]

I just typed your expression in exactly as you have it and it works fine. Are your tables linked?
SELECT Invoice.Parts, Invoice.Labor, Invoice.Misc, Order.[Standard Cost], Order.Quantity, [Standard Cost]*[Quantity]+[Parts]+[Labor]+[Misc] AS Expr1
FROM [Order] INNER JOIN Invoice ON Order.Orderid = Invoice.Orderid;


[This message has been edited by Jerry Stoner (edited 01-15-2002).]