Displaying Data in Reports

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

Guest

I am in the process of creating a report that will display data from multiple
tables.

Example:
I created a field for defined ages (100 Months, 200 Months, etc)
On the form I have a drop down box that populates from a talble named "Age"
and a table named "Age" in my primary table where this information is kept.

When I select the Age from the drop-down list, lets say 100 Months, I can
review the table and the record shows 1, this is also what gets reported on
my reports, I would like to populate the report with the actual data of 100
Months, but I can not figure this one out, can someone tell me what I am
doing wrong?

Thanks in advance for your help.

Garyp

Grp at T K S O L dot c o m
 
I think "1" is the actual data. It sounds like you might have created a
lookup field in a table. You might want to read about the evils of this at
http://www.mvps.org/access/lookupfields.htm.

To get the "100 Months" to display in your report, add the Age table to your
report's record source and join the proper fields.
 
Back
Top