How do I add a field to an existing Access 2003 report?

[Guest]

I canged a table structure after creating a working report.
In an attempt to normalize the database, I removed one field from one table
and moved it to a new table.

Now my report doesn't work any more because the field no longer exists.

The report doesn't know about the new Table. The report is still looking
for the dleted column in the old Table.

When I try to run the report, it now asks for the value of that field.
Since REPORTING the value of that field for MANY RECORDS is the entire
purpose of this report, this is useless to me, and I suspect it would stuff
that same value into every record's output.

I would rather not re-create this report as I find the Report builder in
Access hard to use. (This question is an example...)

Larry Linson (MS MVP) answered a similar question indicating that someting
needs to be changed or added to RecordSource or Control Source.

Unfortunately, he did not describe where to find and alter these sources.

Help!

 

[Marshall Barton]

I canged a table structure after creating a working report.
In an attempt to normalize the database, I removed one field from one table
and moved it to a new table.

Now my report doesn't work any more because the field no longer exists.

The report doesn't know about the new Table. The report is still looking
for the dleted column in the old Table.

When I try to run the report, it now asks for the value of that field.
Since REPORTING the value of that field for MANY RECORDS is the entire
purpose of this report, this is useless to me, and I suspect it would stuff
that same value into every record's output.

I would rather not re-create this report as I find the Report builder in
Access hard to use. (This question is an example...)

Larry Linson (MS MVP) answered a similar question indicating that someting
needs to be changed or added to RecordSource or Control Source.

Unfortunately, he did not describe where to find and alter these sources.

The record source of a form/report is a table or query that
provides the data.

In your case, it sound like you need to create a query that
Joins the two table so the fields from both tables are
available to the report. After you get the query working
as needed, then open the report in design view and enter the
name of the query (instead of the table you now have) in the
report's RecordSource property.