Dynamic reports

[SharkSYA]

Hi,

Hoping someone can help. I have a booking database which has rooms and
dates. When a booking is made, it puts an 'X' in the box(Thanks Bob).All
well and good. The problem is caused by the need to add new rooms. The
queries,etc all work as they should. With respect to the report I have the
option of having dates across the top and rooms down the side or vice
versa.If I set up a report in the standard way, then either it won't show
the new rooms unless they are manually added to the report or I get an error
in the date as soon as it gets to the next day and 'drops' off the date from
the query. Any help/guidance would be greatly appreciated. I know nothing
about VBA so SQL advice would be greatly appreciated, if necessary.

 

[Larry Linson]

As you have given no details about the data being reported, we aren't going
to be able to give you any useful advice. It is not at all clear how your
report is arranged that you'd have to add rooms to the report. I can't
imagine designing this kind of application in a fashion that it would be the
case. But a report is not independent of the data on which it is based.

Please clarify, with details on your data and on the design of the report.

Larry Linson
Microsoft Access MVP

 

[SharkSYA]

Sorry about that. The report has rooms across the top and the dates are down
the left hand side. If a room is booked an 'X' appears in the appropriate
box. My problem is that when rooms are added they appear in the query but
not in the report based in that query. I hope that this is clearer. It isn't
imperative that the dates be down the left, they could be across the top and
the rooms down the side.



--
SharkSYA

As you have given no details about the data being reported, we aren't going
to be able to give you any useful advice. It is not at all clear how your
report is arranged that you'd have to add rooms to the report. I can't
imagine designing this kind of application in a fashion that it would be the
case. But a report is not independent of the data on which it is based.

Please clarify, with details on your data and on the design of the report.

Larry Linson
Microsoft Access MVP

 

[Duane Hookom]

Consider the sample calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4. There is a
week-at-a-glance style report that uses data for some of the settings and
could use even more data if you need.

--
Duane Hookom
MS Access MVP

Sorry about that. The report has rooms across the top and the dates are down
the left hand side. If a room is booked an 'X' appears in the appropriate
box. My problem is that when rooms are added they appear in the query but
not in the report based in that query. I hope that this is clearer. It isn't
imperative that the dates be down the left, they could be across the top and
the rooms down the side.

 

[Mike Storr]

Without really seeing what you're trying to do, I envision your attempting
to re-create a spreadsheet type of report (rooms as rows, dates as columns).
If that is true, I have attempted to do this once before, and just got fed
up with it. So I decided to re-plan how the data was being grouped. Perhaps
the simplest thing to do, is just re-think how the information gets listed.
Perhaps group by date, and list rooms under that, or group by rooms, and
list all booked dates under it. Just a thought.

Mike Storr
www.veraccess.com