How do you add fields to a report once you have created it with t.

D

Dirk Goldgar

Steve said:
How do you add fields to a report once you have created it with the
wizard
Click to expand...

First you have to get the fields into the report's RecordSource. Open
the report in design view, open its property sheet, go to the Data tab,
click on the Record Source property line, and click the "build" button
(caption "...") that will appear at the end of the line. If the
RecordSource already includes the fields you want, fine; just close it.
Otherwise, add the new fields to the query grid, and then close the
query designer, allowing it to update the property.

The new fields should now be available in the field list for the report,
and you can drag them onto the report wherever you want them.
 
S

sorrywm

I am working with a report that I did not design; I am trying to update it to
include additional information that was not in the original query on which it
was based. I added a field to the query and saved it, and then I tried to add
the new field to part of an expression in the report, but it was not on the
report's Field List. What am I doing wrong?
 
J

John Vinson

I am working with a report that I did not design; I am trying to update it to
include additional information that was not in the original query on which it
was based. I added a field to the query and saved it, and then I tried to add
the new field to part of an expression in the report, but it was not on the
report's Field List. What am I doing wrong?
Click to expand...

Open the Report in design view. View its Properties; click the ...
icon on the Recordsource property (on the data tab). A Query design
window will open. Make sure that the new field is included, and close
the query window; accept Access' offer to save the updated SQL.

John W. Vinson[MVP]
 
Top