How do I add to new field to a finished report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was using the report wizard to design a report. When I was finished, I
decided I needed some additional items from tables that I did not choose up
front. How can I go back and add items to the fields list? I am using two
different tables linked by one field.
 
I was using the report wizard to design a report. When I was finished, I
decided I needed some additional items from tables that I did not choose up
front. How can I go back and add items to the fields list? I am using two
different tables linked by one field.

Go back to the query that is the report's recordsource (Click on the
Report's Property Sheet's Data tab. Then click on the little button
with 3 dots that appears on the Record Source line.) and add them to
the grid. Save the changes.
Then you can use the Field List tool button to add the new fields to
the report.
 
Open the report in design view.
If the fields are in the query that is the record source for your report,
you can just add controls to display them and then bind the controls to the
fields. If the fields are not in the record source, you will have to modify
the record source query to include the fields.
 
Back
Top