Hide Duplicates

  • Thread starter ironwood9 via AccessMonster.com
  • Start date
I

ironwood9 via AccessMonster.com

My report lists projects by date, descending - there are typically about 4-5
projects per day - I only want the date to show once, thinking that selecting
"Hide Duplicates=Yes" in the properties of text box, but that causes #Name?
to be displayed - if I set Hide Duplicates=No, then it works fine, but I
don't want the same date to appear over and over
 
C

Carl Rapson

ironwood9 via AccessMonster.com said:
My report lists projects by date, descending - there are typically about
4-5
projects per day - I only want the date to show once, thinking that
selecting
"Hide Duplicates=Yes" in the properties of text box, but that causes
#Name?
to be displayed - if I set Hide Duplicates=No, then it works fine, but I
don't want the same date to appear over and over
Click to expand...

Could you group on the date instead of sorting? That way the date could only
be printed once, in the Date group header.

Carl Rapson
 
Top