Table - Validation Rule - Date

T

tmwwtw

hi,
I'm new in access. I want to make a database like Hotel Reservatio
System. In table, I made 3 tables. Table customer, reservation an
room. In reservation table, I want to make 3 fields. ReservationDate
LoginDate, and LogoutDate.
My problem is how can I make validation rule for these fields. I wan
to set LoginDate must be before LoginDate and LogoutDate must be afte
LoginDate.
Please help me in validation rule.
thanx.
 
M

Mark Reed

What you want to do is very acheivable is Access. I think you're trying to
do this in the table definition though, which is wrong.

I would set up a form for your reservations and run a little VBA code in the
'after update' property for each date control you wish to check.

Mark. mcse.
 

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

Validation Rule 2
Access Validation rule of 1 field based on a field of another table 1
Validation rule problem 7
db design 3
Parameterize validation rule and text? 5
Validation Rule assistance 0
Validation Rules 23
Puting a date and time into a user log table 15

Top