Querry link to Report

[bhm7319]

I created querry from the table, and then I created report from the querry.
Now I had to add some more field to the querry. I need to show those newly
added fields in the report. Is there a way to add those fields in the report
or do I have to create new report and delete the old one? Can I edit existing
report based on new querry?

Thanks.

 

[John Knox]

Hi Bharat

No you don't have to create a new report from scratch. While the report is
in design view, you only need to open the field list by clicking the field
list button on the "report desing" toolbar. This will show all the
available fields from the query that you based the report on. You can also
change the record source of the report to a new query by changing the record
source in the properties dialog box.

Hope this helps

Regards

John

 

[Marshall Barton]

I created querry from the table, and then I created report from the querry.
Now I had to add some more field to the querry. I need to show those newly
added fields in the report. Is there a way to add those fields in the report
or do I have to create new report and delete the old one? Can I edit existing
report based on new querry?

Open the report in design view and display the little Field
List window (View menu).

Drag each desired field from the list and drop it in an
appropriate place on the report. Use the text box's handles
to size and position the text boxes as you ant them. If
needed, double click on a text box to display the Property
window and adjust the font, and other properties.