Add Field to Table, BUT it does NOT appear in Report field list

[jsteff]

Report is done.
Table has been modified to add a new column. DONE

BUT when I go into the report design to add the column to the report, the NEW field does not show up on the field list.

How do you update the field list in "Reports" to reflect the current content of the tables?


thanks.

 

[Crowley16]

restart access?

or hows about doing it manually, it's not difficult...

--------------------
Procrastinate Now!

 

[beverlee]

Are you sure that your report is based on the table itself and not on a query? If so, you would have to include the new field in the query in order for it to show up on the report field list. Just a suggestion!

 

[jsteff]

I found it.... the query used in the report had a field list in the SELECT not a table reference.

thanks