status query

[yoavchen]

i am trying to make a cross tab query that will give me the status of the unavalble rooms in my hotel
somthing like that:


romm num today today+1 today+1 today+2 today+3 today+4 and so on...
1 X X
2 X X X
3 X X X
4 X X
5 X

thas how i will see where do i have a free rooms in a range of dates that i want to insert.

please advice,

Thanks

 

[Jibbadiah]

View this thread and you will see why it isn't such a good idea.

http://www.access-programmers.co.uk/forums/showthread.php?t=87292

Alternatively, look at the queries, new, cross-tab query wizard.