Table - Validation Rule - Date

  • Thread starter Thread starter tmwwtw
  • Start date Start 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.
 
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.
 
Back
Top