Query to Update Only Last Column

[rocky09]

Hi All,

I have a table "Service_Information" with 6 Columns like ID, Part_No, Part_Name, Description, Morning_Records, Evening_Records.

Up to Morning_Records, the User will populate the Data with the help of User Form.

I would like to populate the Column "Evening_Records" from Other Table "Evening_Variables" where the Data Exists. like Vlookup in Excel. Is it possible to do with Query?

Thank you in advance,

Best Regards,

 

[plog]

Yes, but that's not how databases are to work. You don't store calculated or duplicate data, instead you retrieve it when you need it.

So what you should do is build the query to generate that data, not build a query to populate that data into a table.