My grouping and sorting doesn’t work in Access 2007 Report design

Topic

New Reply

I can’t get my report to group and give me a total at the break. I am used to 2003. I know it is something I just am not doing right in 2007. I have a field “Type of Coverage”. I want it to group and give me a total line. It gives me a total line after ever Type of Coverage. I am attaching a file that I hope someone can see what I am doing wrong.

Reply | Quote

Replies

You have got a Product Order column that is causing this, delete this column.

Reply | Quote

Check your Sorting/Grouping. I’m betting there is another field being sorted before the “Type of Coverage”. You can leave that field in the report, just remove it from sorting.

Reply | Quote