problem

Hi. Ive made a hotel booking system program.
I have to have a stats page which shows the rooms currently booked and rooms available.
I dont have a clue how i could display this information, only idea i had was to use a find command but wasn't sure.

Any ideas/help is much appreciated.

Thanks.

I assume the table has a field for Vacant or Occupied? Just run an SQL query to return the table contents to a flexgrid, or just display the whole thing in a flexgrid. If you use SQL, you could use "order by" and sort them by room number, vacancy, etc.