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.
Thanks in Advance.
J. Turner