A
a
thank you
Table1 (basic data not change "permanent data")
Begin date end date no of days
1/1/2004 5/1/2004 4
15/1/2004 20/1/2004 5
22/1/2004 25/1/2004 3
table2
(the data of this table fill by form contain one combo box for example)
begin date
1/1/2004
2/1/2004
5/1/2004
22/1/2004
17/1/2004
the rule here for fill date is begin date must be between begin date and
end date in TABLE1
explanation and the question:
begin date in table2 is reservation table and take data from basic data
table1 so I want to make validation rule or query or SQL or VBA to check the
date enter in the combo box if the date is not equal or not between begin
date and end data the computer display msgbox (you have enter date not in
your account)
Table1 (basic data not change "permanent data")
Begin date end date no of days
1/1/2004 5/1/2004 4
15/1/2004 20/1/2004 5
22/1/2004 25/1/2004 3
table2
(the data of this table fill by form contain one combo box for example)
begin date
1/1/2004
2/1/2004
5/1/2004
22/1/2004
17/1/2004
the rule here for fill date is begin date must be between begin date and
end date in TABLE1
explanation and the question:
begin date in table2 is reservation table and take data from basic data
table1 so I want to make validation rule or query or SQL or VBA to check the
date enter in the combo box if the date is not equal or not between begin
date and end data the computer display msgbox (you have enter date not in
your account)