Add field to Access Report

[Guest]

This has to be an easy one for someone out there. We have a previously
created report in Access 2000 that we don't want to recreate. However, we
are trying to add one more text field to the report from a different table.
Can we either get back into the Wizard somewhere or can we add the field in
design view? Tried everything we could find, but nothing worked. Thanks.

 

[Allen Browne]

Open the report in design view.
Open the Properties box (View menu.)
Looking at the properties of the report (not of a text box), the first item
on the Data tab is RecordSource. This indicates which table or query the
report gets its data from. You need to create a query that uses both tables,
and then set the RecordSource property to the name of that query.

Alternatively, you might be able to craft a DLookup() expression in the
ControlSource of a text box to look up the value in the other table. More
info on this approach:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[Guest]

Thanks, Allen. I will try this.

Colleen

Open the report in design view.
Open the Properties box (View menu.)
Looking at the properties of the report (not of a text box), the first item
on the Data tab is RecordSource. This indicates which table or query the
report gets its data from. You need to create a query that uses both tables,
and then set the RecordSource property to the name of that query.

Alternatively, you might be able to craft a DLookup() expression in the
ControlSource of a text box to look up the value in the other table. More
info on this approach:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html