I am somewhat new to Access but I kow Sql server. I have an Access table linked to a Sql server table. I want to update on certain fields in the sql table.

I have created a query : with the fields I need updated
SELECT Invoice.invoice _num, Invoice.invoice _date, Invoice.[TOTAL PAID]
FROM Invoice;

can I write a stored procedure that will run this qurerry and update only these fields in my sql server database....