Cannot get CATEGORY NAME in field, just ID (autonumber) for REPORT

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

Guest

How do I get the category NAME to show in a field instead of the category ID
for a REPORT?

I had the same issue for FORMS and I followed the directions, but now when
I'm in REPORTS there isn't ROW SOURCE, COLUMN COUNT, BOUND COLUMN, CONTROL
SOURCE, COLUMN WIDTHS...so how do I do it?
 
How do I get the category NAME to show in a field instead of the category ID
for a REPORT?

I had the same issue for FORMS and I followed the directions, but now when
I'm in REPORTS there isn't ROW SOURCE, COLUMN COUNT, BOUND COLUMN, CONTROL
SOURCE, COLUMN WIDTHS...so how do I do it?
Click to expand...

Base the Report *ON A QUERY* joining your table to the Category table.

I suspect you're another victim of the abominable Lookup misfeature;
if so your table *appears* to have the Category in it, *but it
doesn't*; what the table actually contains is an ID, concealed from
view.

Just create a Query; add your main table; add the Category table,
joining CategoryID in the main table to CategoryID in the Category
table. Select the category text field from the category table, and all
the other fields you want to see from your main table. Use this Query
(rather than the table) as the recordsource for your report.

John W. Vinson[MVP]
 
Back
Top