Query help

[cg084]

Hello,

I have a database with a table called date. In there is every date from now until 2007. I have another table called booking which i will populate with data. Reference numbers, Start Date, and and End Date.

After which i will click a button to search the records and for each date in the date table between the booking table records start and end dates assign a value to a text field in the date table.

However i would like the query to ensure that all of these dates are null and that there is no other text value allready in this text field in the date table. If there is any other value in this date table for the query to display a message box and cancel the update.

As an addition but is not essential i would like to open another form in the database should this happen. But not essential.

Hope you can help

Cheers and Happy New Year.

 

[Blorf]

I have some questions.

You write that after you click a button, the update happens. This means that only one start and end date are being looked at after each button push?

Also, the values in the text field are by default null, but you want a warning if some other data range put something in the text fields?

 

[lespaul]

And just an aside - rename your table. Date is a reserved word in most programs. Make it ValidDates or something.