Need help stopping same dates showing up on report.

[thrainpa]

Hey there, basically I have information being show by date in my report like this:

Number - Name - information - 01/12/2011
Number - Name - information - 01/12/2011
Number - Name - information - 01/12/2011
Number - Name - information - 05/12/2011
Number - Name - information - 05/12/2011

However, I've seen reports do this kind of layout:

Number - Name - information - 01/12/2011
Number - Name - information - 
Number - Name - information - 
Number - Name - information - 05/12/2011
Number - Name - information -

Where the duplicate dates are omitted in the report for a clearer view, how can I do this?

 

[vbaInet]

Look for the Hide Duplicates property of the Date control and set it to Yes. You will find Hide Duplicates in the Property Sheet of the control under the Format tab.

 

[thrainpa]

Look for the Hide Duplicates property of the Date control and set it to Yes. You will find Hide Duplicates in the Property Sheet of the control under the Format tab.

This answer was exactly what I was looking for, thank you very much!

 

[vbaInet]

You're welcome!