Checking Availability

[Sizwe_1]

how do in go about in order to check availabili in a form..

[hericles]

Are you wanting to validate a form or do something else? Your question isn't very clear.

[Sizwe_1]

i want to create an form to check availability of a room, i have something like this,
select rt.RoomName from Room rt, [Availability] rd
where rt.RoomName-rd.RoomName (FORMAT([rd.CheckIn], 'MM/dd/yyyy')) not between 'selectdate' and 'selectdate' and (FORMAT([rd.CheckOut],'MM/dd/yyyy'))
not between 'selectdate' and'selectdate'
but the problem is "i dont know how to go about in excecuting it in the form

[hericles]

On your form you would need two text boxes (as the simplest solution) or two calendar controls that the user can use to enter the two dates.
On form submission you then read those two values and make them parameters in your query.
If you have done any code around the form, post it up. We work better with examples.