Edit fields in a table based on results of a query

I have a table with jobs. With a query i find the date of the last job of every customer. Now i would like to write these dates to a special field in the table address. Can you help me?