Adding a new field to an existing report

[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

 

[Jerry Whittle]

If the record source for the report is a query or SQL statement, you'll need
to add the new field there first.

 

[Marshall Barton]

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?

No. You need to modify the report's record source query to
include the new field.

 

[Zahir Shariff]

Thanks for responding
It is not a query or SQL statement

 

[Jerry Whittle]

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?