I am using a table that has and ID field and HdASort field. I am attempting to get the following resulst:

Vacc A
555-5555-55555
666-6666-66666

Vacc B
888-8888-88888

But instead I'm getting

Vacc A
555-5555-55555

Vacc B
888-88888-88888

Vacc A 666-66666-6666

I tried working around it by using an sort field and order by sort number Vacc A being highest Vacc D being lowest but that only gives me multiple sheets everytime the id changes.

Jeff T.