Querry link to Report

B

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.
 
J

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
 
M

Marshall Barton

bhm7319 said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top