I think I got it wrong again.......

[anthony.carter]

I have a report that I have based on a table. It has been successfully
formatted and laid out. Frankly it looked really good. I was very
proud of it. It has struck me, however, that I have based it on the
table when it should have been based on a query (with identical fields
to the table).

Is there any way to change the link of the report to the query instead
of the table or is it necessary to go through the whole process of
designing the report again?

Additionally, there is a need to have a report based on a second query
(also linked to the same, original table). What I mean is that there
is a table and two different reports are required, one to show a
specific building and the other to show the buildings that are
occupied.

Please could some one tell me its possible?
(Even if it means lying!!)

Thanks,

Regards,

TC

 

[Allen Browne]

To change the report so it reads from a query instead of from the table:
1. Open the report in design view.
2. Open the Properties box.
3. Set the RecordSource property to the name of the query.

RecordSource is the first item on the Data tab, when looking at the
properties of the Report (not of a text box.)

You might be able to use a subreport in the Report Footer of your existing
report to show data from another query. That's probably easier than trying
to design a UNION query.

 

[anthony.carter]

well that was easy!!

Thanks.

TC

To change the report so it reads from a query instead of from the table:
1. Open the report in design view.
2. Open the Properties box.
3. Set the RecordSource property to the name of the query.

RecordSource is the first item on the Data tab, when looking at the
properties of the Report (not of a text box.)

You might be able to use a subreport in the Report Footer of your existing
report to show data from another query. That's probably easier than trying
to design a UNION query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.








- Show quoted text -