Validation between two tables? maybe?

Joined
Sep 5, 2011
Messages
1
Reaction score
0
I am pretty new to Access and am trying to build a database based on VIPs that stay at my hotel. Basically I am stuck at a point where I would like access to assign the appropriate week number a VIP stayed based on their check in and out dates. I currently have two tables, one that defines the week number based on the week start and end dates and another that has all the guest info including the check in and out dates. So I was wondering if there is a way to do this?

Any help is wonderful!
Thanks
 
Back
Top