Wonderful!
I had a same problem like the one above in MS Access 2000 and your solution have solved it wonderfully. And thank you and My God for it.
mathsara...
User Profile
Collapse
-
UnOccupied Rooms
I am developing a database in Ms Access 2000 about accommodation reservation. The rooms may not be occupied in a sequence always, for eg. 1,2,6,9,12....e tc. What I would like to know is, how can I find out which rooms are unoccupied like. eg in the above case: 3,4,5,7,8,10,11 etc.
Hope someone will help me with a vb/vba code. Thanks in advance.
No activity results to display
Show More
Leave a comment: