field list in a report

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

Guest

MS Office XP: Access 2003?
I have an existing report. I recently updated the tables this report is
based on by adding additional fields. How do I get my report field list to
reflect this change? I would like to add the new data to an existing report.
 
If you r report is based on the table, then the fields will be there when
you open the report in design-view.

If the report is based on a query (most likely) then you will need to update
the query to include the new fields.

Rick B

DeerGeek said:
MS Office XP: Access 2003?
I have an existing report. I recently updated the tables this report is
based on by adding additional fields. How do I get my report field list to
reflect this change? I would like to add the new data to an existing
Click to expand...
report.
 
"Rick B" wrote
. . .
If the report is based on a query
(most likely) then you will need to update
the query to include the new fields.
Click to expand...

With the Report open in Design View, right click the upper-leftmost little
square and choose Properties, then click the Data tab, and you'll see the
RecordSource. You can click the box with three dots on the right to open the
Query Builder to edit it.

Larry Linson
Microsoft Access MVP
 
Back
Top