So I'm trying to use an update query to update a due date field from table A, using the latest event date from table B per AutoID (table A) + A frequency (days).
I've tried a few different ways but no closer, any suggestions?
(I'm quite new to access and rarely touched update query)
thanks.