Missing fields

[Guest]

I have a report with 4 fields in it and works fine. There are other fields
in the table that I want to "insert" into the report, however, when I go into
design view of the report and select "view, field list" none of the other
fields are in this list.

Suggestions?

Thanks.

Ty

 

[Duane Hookom]

You may need to alter the Record Source property of the report to include
the additional fields.

 

[Guest]

Duane - how do I "alter" the reord source property of the report?

Thanks.

Ty

 

[Duane Hookom]

Find it, then click the [...] button to the right of the property to enter
the SQL/query design view. Make your changes and close the query design.
When asked if you want to save your changes, say yes.