Adding a new field to an existing report

  • Thread starter Thread starter Zahir Shariff
  • Start date Start date
Z

Zahir Shariff

I created a new field in an existing table and want to add that to an
existing report. The 'new field' doesn't show up in my Field List in Report
Design view.
Do I need to create a new report?

Thanks in advance
 
If the record source for the report is a query or SQL statement, you'll need
to add the new field there first.
 
I created a new field in an existing table and want to add that to an
existing report. The 'new field' doesn't show up in my Field List in Report
Design view.
Do I need to create a new report?
Click to expand...


No. You need to modify the report's record source query to
include the new field.
 
Very strange. Have you tried closing the database after creating the new
field in the table; reopening the database; them modifying the report?

Other than that, you might want to make a backup of the database then do a
compact and repair.

Just a thought: what's the name of the new field in the table and what data
type?
 
Back
Top