Thanks for all of your advise. I fixed the issue last Friday morning but didn't have time to get on here to let you all know.

I know my code...

We have created a table with all the data in it. now we need to write a query that says if charge code appears twice then give me the code...

Grant,

Thanks for the advice but we did try that before I posted and it doesn't work. what is going on in I get one sum in query A(correctone) and another...

Great!!! thanks for the suggestions. I will check subreporting out and get back if that is not what I need.

Thanks to all that replied I have figured it out with some clues from Dan...thanks guys and gals...

I GOT IT Thanks...

I have changed it in my code and still getting the same results...

I want it to look something like this

FIN Class 0-30 31-60 61-90 91-120 ...

Dan I have reposted the code and results but I will answer your question

I want it to look something like this

FIN Class 0-30...

Lets try this way...below is my code and a few results....I need to get the results to only list on ins company and there total and not 5 BCBSNC i...

Thanks so much for all your guys help. I don't completely understand the pivot idea but I do have a coworker that does and we are going to look at...

I knew it was something simple. The left join gave me data back. Thanks...

awesome. thanks

A lot of things I have read indicate that I should be processing all changes as set-based transactions, and that looping is BAD. But, I am trying to understand...

Tyson

Thanks so much...that fixed it...I had a brain fart. Monday 😀