Hide Duplicates

[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

 

[Carl Rapson]

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

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