[AccessD] Hide Duplicates Not Working

Have you repaired the database? Something's wrong. Now, as a long shot, you 
might check the underlying query and make sure there first record doesn't 
have a bunch of empty fields, but I don't think even that would do it. The 
report shouldn't care if the first value in the report for that field is 
blank, but maybe it's a bug. Just a guess.

Have you tried Hide Duplicates in other reports in the same database?

Susan H.


> No.  Any field.  Header.  Group header.  Detail.  They all show #Name? 
> When
> set to hide duplicates.
>
> R
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
> Sent: Thursday, July 02, 2009 3:58 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Hide Duplicates Not Working
>
> Rocky, does Hide Duplicates work Okay on other fields in the same report?
>
> Susan H.
>
>
>> Dear List:
>>
>> I have a report which prints fine until I set one of the detail fields
>> to Hide Duplicates - Yes.  Then I get #Name? in the field.  Has anyone
>> seen this behavior before?
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com