First, If you can readily calculate it why store it?
If you have a reason for storing, try:
1. Add the Total_YTD column to the table.
2. Change query to
UPDATE tblTableName
SET tblTableName.Total_YTD =
(tblTableName.[Sold YTD] = tblTableName.[Used YTD]);
Kevin C
"JJM0926" <jj*****@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...
I've got two columns that I want to add the values and then insert it
into the table as a new column. I've got the query as such:
Select [Sold YTD]+[Used YTD] As Total_YTD
>>From Parts;
The problem I run into is how do I then take the results Total_YTD and
insert it back into the table.
Any insights would be greatly appreciated. Thanks.