Add a new field to an existing report

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a new field to an existing report 4
New User - adding to an existing report 1
Adding field to Report 2
Sharepoint Lookup data field displays Id not data 1
Adding new fields to an old report 1
Add a field to report 1
Adding a New Field to an existing Report 1
Querry link to Report 4

Top