Validation between two tables? maybe?

B

britty21

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visual Studio and Macros 1
Detemine sales order based on plac changes and not sales figures -mathmatic problem to solve 1
Calculate a date based on a weeknumber 2
Creating a Query based of two diffent data tables 1
Access access help please 2
Access - Database - Form - Field Validation - LookUp function 3
More query issues ..... 2
I need a function with Dates 3

Top