new fields

[skigal]

When I add new fields to a table or query that is feeding a report, those new
fields do not show up on the field list for the report. Is there a way to
get them on the list as available fields for the report or do you need to
start the whole report over again to add a new field?

 

[fredg]

When I add new fields to a table or query that is feeding a report, those new
fields do not show up on the field list for the report. Is there a way to
get them on the list as available fields for the report or do you need to
start the whole report over again to add a new field?

First add the new fields to the underlying table.
Then, if the report record source is a query, add the fields to the
query.
Now they should be available in the report Field List tool button.

 

[Ofer Cohen]

In the report RecordSource you specified which fields you want to include in
the report

Select TableName.FieldName1 , TableName.FieldName2, TableName.FieldName3
From TableName

And this is why when you add a new field to the table it doesn't apear in
the report,
Instead you can specify to include all the fields from the table in the report

Select TableName.* From TableName

That way every time you add a field to the table it will display it as an
option in the report
==================
To change the current setting in your report, so you wont have to create it
again, open the Report properties, locate the cursor in the RecordSource
property, click on the button it will show you the record source, you can
either add the field or change it to the way I showed you above.