White Space in a Report after Hide Duplicates

[MarieD]

My report is totalling after each procedure type and I have told the properties to 'hide duplicates', but the white space is still showing on the printed report, before the total. How do I remove the white space and keep the totals?

I meant to include that I am using Access 2007.

 

[cookiegary01]

Suggestion:
make a "Total query" and use that as the report source, instead of using a detailed report and hiding all duplicates?

 

[MarieD]

This is not working either. I've created the totals query, totaling only the procedures for each tech. I've made 'hide duplicate' yes, 'can grow and can shrink' to yes.

 

[cookiegary01]

If you have grouped by procedure type and totalized per procedure type, then what duplicates are you trying to hide in the report? Other details per group?

Can you show the results in a reply post and specify what needs to be hidden?

 

[MarieD]

I need for the report to show the procedure name one time with the total (see the
ankle brachial index is showing six times?) I want it to appear one time with the total of 6.

Copy Of Echo by Technologist qryTechnologistProcedureAccessTotalsProcedureADMINISTRATOR, PROGRIS ANKLE BRACHIAL INDEX6ADMINISTRATOR, PROGRIS ANKLE BRACHIAL INDEX6ADMINISTRATOR, PROGRIS ANKLE BRACHIAL INDEX6ADMINISTRATOR, PROGRIS ANKLE BRACHIAL INDEX6ADMINISTRATOR, PROGRIS ANKLE BRACHIAL INDEX6ADMINISTRATOR, PROGRIS ANKLE BRACHIAL INDEX6ADMINISTRATOR, PROGRIS AORTA DUPLEX SCAN LIMITED1ADMINISTRATOR, PROGRIS ARTERIAL DUPLX BIL LOWEXT3ADMINISTRATOR, PROGRIS ARTERIAL DUPLX BIL LOWEXT3ADMINISTRATOR, PROGRIS ARTERIAL DUPLX BIL LOWEXT3

 

[cookiegary01]

If your query resluts also show this, then your Total query is incorrect.
Other option is your report is not correctly Grouped / structured.

Try this link to learn about grouping your report values:
http://office.microsoft.com/en-us/a...e-values-in-an-access-report-HA001034582.aspx

 

[cookiegary01]

If it is the query, then Check this for "Totals query":
http://office.microsoft.com/en-us/access-help/count-data-by-using-a-query-HA010096311.aspx