How can I hide duplicate data or records in groups, in Access 2007 Reports? Basically, you'd use the Property Sheet and set the option as we show in our training video to Yes. Keep in mind though that this will only hide the duplicated field and NOT the record in the report. Additionally, we'll show you how to apply Conditional Formatting - color coding text if a condition or criteria is met. The list goes on with: learning how to add a counting Text Box field to your report to count up the number of records or fields, and display those totals either at the end of your report or at the bottom of each page. Formatting labels, adding the Report's Title Box and more!

Purchase the training video and you can see this in action for yourself!