SUMMARY EXPRESSION showing ID and not NAME

[Guest]

I created a REPORT that lists the household inventory by CATEGORY (i.e.
furniture, collection, jewelry, etc). I have a SUMMARY EXPRESSION after each
CATEGORY that states the CATEGORYNAME and how many detail records are listed
within the CATEGORYNAME. The problem follows:

In the REPORT the CATEGORYID actually shows in the COMBO BOX (not
CATEGORYNAME) as the CONTROL SOURCE, the ROW SOURCE TYPE is TABLE/QUERY and
the ROW SOURCE is CATEGORIES. So, when I created the SUMMARY EXPRESSION
="Summary for " & [CategoryName] & " = " & Count(*) & " " &
IIf(Count(*)=1,"detail record","detail records") it keeps prompting me ENTER
PARAMETER VALUE for CATEGORYNAME. If I change the SUMMARY EXPRESSION to read
CATEGORYID (where CATEGORYNAME is), then it works, but it shows me the ID
(number) and not the NAME.

Help!

 

[Duane Hookom]

Add the Categories table to your report's record source. Consider reading
how many of us experienced developers feel about lookup fields
http://www.mvps.org/access/lookupfields.htm.

 

[gavin]

Add the Categories table to your report's record source. Consider reading
how many of us experienced developers feel about lookup fields
http://www.mvps.org/access/lookupfields.htm.

Duane,
I don't pretend to understand much of what is written on
http://www.mvps.org/access/lookupfields.htm but I get the gist that you
don't like look up fields. What's the recommended alternative?



Regards,



Gavin

 

[Duane Hookom]

-Don't allow users to view tables
-Limit interaction to forms where you use combo and list boxes
-Add the "lookup" table to the record sources of reports.