Adding a field to a report

[LKJones]

I have a report based off a query, I have modified the query (added a field)
and now I want to update the form to show this new field. I can't seem to
find a way to easily add a new field. Any help is appreciated!!!

 

[Rick B]

You say you want to modify the "form" but I assume you meant the report?

Just open the report in design-view. Open the "field List" if it is not
already opened, and find the new field. You can then drag it to your report
and modify it to meet your needs.

 

[Marshall Barton]

I have a report based off a query, I have modified the query (added a field)
and now I want to update the form to show this new field. I can't seem to
find a way to easily add a new field.

Open the report in design view. Add a text box control and
select the field from the query using the drop list at the
right side of the text box's ControlSource property (double
click the text box to display the property sheet).

 

[LKJones]

Yes, I meant to say report. I've tried doing that, but the new field is not
shown in the field list, any other suggestions?

 

[Rick B]

It has to be if you updated and save the query and if the query is indeed
the record source for the report. Open the report parameters and verify
that you are using the query as the source. Click the ellipse button [...]
next to it and your query should open in design view. Verify that the field
is there.