Hi there, i need some help with this problem....


SELECT * FROM [Date] WHERE (date.date = #datevar#) AND (Date.RoomId = Roomvar)

datevar = date()
do...
make date
create SQL
if record count <> 3 then
add date to list
end if
loop until (365 dates checked)

I am trying to a rooms availablity for a date, if the room is free then add it to a list box.

The method listed above is really slow because you have to keep generating a record source for each date.

I you have any ideas then let me know...

Rohan