Calculated Field in a Query

[AshK]

I have a query with two tables (1 to M) I need to sum a value from the many side with totals turned on. Summing works fine [SumofAmount]. Then I am creating a profit field where a field from the parent table [Sold Price] subtracts the [SumofAmount]. But I am stuck here as I get error "enter Parameter". SQL is as under:

Will appreciate some help.

SELECT Vehicles.[VIN Number], Vehicles.Make, Vehicles.Model, Vehicles.Year, Vehicles.[Price (JYP)], Vehicles.[Price (AUD)], Vehicles.[Sold Price], Sum(tblExpenses.Amount) AS SumOfAmount, [Sold Price]-[SumofAmount] AS Expr1
FROM Vehicles INNER JOIN tblExpenses ON Vehicles.VehicleID = tblExpenses.VehicleID
WHERE (((Vehicles.SStatus) Like "*Sold*" And (Vehicles.SStatus)<>"Added to Fleet"))
GROUP BY Vehicles.[VIN Number], Vehicles.Make, Vehicles.Model, Vehicles.Year, Vehicles.[Price (JYP)], Vehicles.[Price (AUD)], Vehicles.[Sold Price], [Sold Price]-[SumofAmount];

[June7]

Can't have alias name of aggregate calculation in GROUP BY. Remove [Sold Price]-[SumOfAmount] from the GROUP BY clause.

The Sum(Amount) must be repeated in the Profit calc. Make sure the query shows "Expression" under the Profit calculated field.

The second filter criteria doesn't appear necessary.

SELECT Vehicles.VehicleID, Vehicles.[VIN Number], Vehicles.Make, Vehicles.Model, Vehicles.Year, Vehicles.[Price (JYP)], Vehicles.[Price (AUD)], Vehicles.[Sold Price], Sum(tblExpenses.Amount) AS SumOfAmount, [Sold Price]-Sum([Amount]) AS Profit
FROM Vehicles INNER JOIN tblExpenses ON Vehicles.VehicleID = tblExpenses.VehicleID
WHERE SStatus LIKE "*SOLD*"
GROUP BY Vehicles.VehicleID, Vehicles.[VIN Number], Vehicles.Make, Vehicles.Model, Vehicles.Year, Vehicles.[Price (JYP)], Vehicles.[Price (AUD)], Vehicles.[Sold Price];

[AshK]

Very grateful for your help. Did not receive the notification else could thank you earlier.