I have a basic report where I sort and count the number of records in a textbase by a field type, e. g., tracking contacts with different departments during one month.

My report always leaves blank lines for each record, then shows the field information and the total, such as Department A, 10, Department B, 15. So there are 10 blank lines before the total Department A, 10, then 15 blank lines before the total Department B, 15.

I'd like a report showing the totals, without a representation of each record. I'm using Sort Key: Level 1 and Calculated Value: Count (1) in a Sort Footer.

In the Form Designer, choose Tools>Form Properties. Set the "Distance between records" to 0.

You may also want to use Tools>Box Properties to set the top offset of your box to 0.

Also make sure that if you have the Sort Key and the Calculation in different boxes that they're both Sort Footers, not one Sort Header and one Sort Footer.

Looks like this is what I want.

Thanks for your help.