Thanks Serrano G
I have those options already set, I guees I should also mention that we are using an access adp file as a front end incase that makes a difference. Basically the way want this report to work is that I have column headers that can start any where on the page, because we have a bunch of other stuff on the page for page and report headers. We haven't figured out yet how to group using ADO as well. I hope that this helps someone to help me.