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.

--
SharkSYA

[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" <sh****@tw.uk> wrote in message news:40******@clear.net.nz...

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.

--
SharkSYA

[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
"Larry Linson" <bo*****@localhost.not> wrote in message
news:Ha*****************@nwrddc02.gnilink.net...

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" <sh****@tw.uk> wrote in message news:40******@clear.net.nz...

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.

--
SharkSYA

[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
"SharkSYA" <sh****@tw.uk> wrote in message news:40******@clear.net.nz...

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
"Larry Linson" <bo*****@localhost.not> wrote in message
news:Ha*****************@nwrddc02.gnilink.net...

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" <sh****@tw.uk> wrote in message news:40******@clear.net.nz...

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.

--
SharkSYA

[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

"SharkSYA" <sh****@tw.uk> wrote in message news:40******@clear.net.nz...

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.

--
SharkSYA