Access 2003: How to add a field to an existing report field list?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to add a field from one of the project tables to the field list on a
report. How do I add to the report field list? Thanks from an Access newbie.
 
Hi Access newbie,

I presume that the report is bound to a table and not a query. I also
presume that the field you are wanting to add is not in the table that your
report is bound to. So, what you need to do is make a query combining the
two tables together. You will also need to make a relationship between the
two tables. It would help to know the fields and tables involved. I could
then give more exact help.

Mandy Jo
 
Need to add a field from one of the project
tables to the field list on a report. How do
I add to the report field list?
Click to expand...

The Field List just displays the names of Fields in the Report's Record
Source. Revise the RecordSource to include the Field and it will,
automatically, appear in the Field List.

If the Field is in a Table related to the Table or Query used as
RecordSource, join those Tables in a Query to use as RecordSource and
include the Field in the Fields retrieved by the Query.

If the Field is not in a related Table, you may be able to use the DLookup
function in the Control Source of the Control in which you want to display
it. Having two unrelated, unjoined Tables in a Query can lead to what is
known as a "cartesian product" (far more data than you likely really want to
have to deal with).

Larry Linson
Microsoft Access MVP
 
Back
Top