Add a new field to an existing report

D

Dane

I would like to add a field that is in the table and on the form, but when I
created the report I omitted the field.
I do not want to re-create the form as it took a lot of time and effort.
Is there a way to add this new field "DETAIL ID" to my existing report?
I did not create the report from a Query.

When I try to add it by creating a Text Box and using the Expression Builder
I get a #Name error message if I pick from the list of fields in Forms. The
"DETAIL ID" Field is not in the Field List.
 
D

Duane Hookom

Find the report's Record Source property and open it in the Query Design
view. Make sure the new field is included in the grid. If you can't find the
field, reply back with the Record Source SQL view.
 
Top