callumwatson
Registered User.
- Local time
- Today, 20:55
- Joined
- Jun 22, 2001
- Messages
- 22
I have a TOTAL field in a table which holds a number which is the total of values in another table. I have successfully written a query to obtain the value from my other data ,however, I don't know how to get the result to automatically my TOTAL field.
I don't even know if an auto generated table field is allowed and possible.
Here is my query (probably hard to follow): -
SELECT Enquiry.[Enquiry Number] AS [Enquiry_Enquiry Number], Sum(Valuation.Value) AS SumOfValue
FROM Enquiry INNER JOIN Valuation ON Enquiry.[Enquiry Number] = Valuation.[Enquiry Number]
GROUP BY Enquiry.[Enquiry Number], Valuation.[Enquiry Number];
NOTE the TOTAL value field I want to update is in the Enquiry Table itself!!
I don't even know if an auto generated table field is allowed and possible.
Here is my query (probably hard to follow): -
SELECT Enquiry.[Enquiry Number] AS [Enquiry_Enquiry Number], Sum(Valuation.Value) AS SumOfValue
FROM Enquiry INNER JOIN Valuation ON Enquiry.[Enquiry Number] = Valuation.[Enquiry Number]
GROUP BY Enquiry.[Enquiry Number], Valuation.[Enquiry Number];
NOTE the TOTAL value field I want to update is in the Enquiry Table itself!!