I am trying to create a query that will update the accounting period based on the date in a table.
Attached is an example.
The tblCalendar has the accounting calendar. The Date field is the first day of the accounting period.
The tblTestDate has test data (dates). I want to update the Period field based on the date in the TRX Date field.
What expression can I use in the qryPeriodUpdate query to return the correct period for the date in tblTestDate?
I appreciate any help. Thank you.