How to Update and Select Simultaneously

[williadn]

How do I update an Access table and then Select rows for display inside one query in Access? Is there a continue command? Or GO command? I want to display the rows right after the update is completed.

Here is my Update code: (it works)

UPDATE [Weekly Metrics]
INNER JOIN lkpPartners ON [Weekly Metrics].Customer=lkpPartners.Partner
SET [Weekly Metrics].SLADueDate = [Weekly Metrics].DateReceived+lkpPartners.[SLA Days];

Here is my Select code: (it works)
SELECT
[Weekly Metrics].[Box Number],
[Weekly Metrics].Customer,
[Weekly Metrics].[DateReceived],
[Weekly Metrics].SLADueDate
FROM [Weekly Metrics];


How do I mix them inside one query? I am not a SQL expert and am an Access programming beginner.

Thanks.