Hide duplicates off = OK; hide duplicates on = #name?

  • Thread starter C. Lombardo via AccessMonster.com
  • Start date
C

C. Lombardo via AccessMonster.com

Hello,
Using Access 2002, I have a report that I created using the report wizard
that consists of information taken from two tables. The join type is "Only
include rows where the joined fields from both tables are equal". On the
detail line of the report, I have changed the properties of all three
displayed fields to hide duplicates. Two of the three fields work fine in
terms of the hide duplicate property. The third field, a text (up to 255)
field, displays OK when the hide duplicates property is off, but shows
#name? message when the hide duplicates property is on. Ideas on how to
resolve this?

Thanks,
Chip
 
Top