Update Access table with Account Period based on date in table
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.
LookupExample.mdb
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.
LookupExample.mdb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER