Viewing 15 posts - 1 through 15 (of 21 total)
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...
October 31, 2011 at 9:48 am
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...
September 29, 2011 at 8:00 am
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...
September 28, 2011 at 2:54 pm
Great!!! thanks for the suggestions. I will check subreporting out and get back if that is not what I need.
August 9, 2011 at 11:47 am
Thanks to all that replied I have figured it out with some clues from Dan...thanks guys and gals...
April 20, 2011 at 9:07 am
I GOT IT Thanks...
April 20, 2011 at 9:04 am
I have changed it in my code and still getting the same results...
April 20, 2011 at 9:03 am
I want it to look something like this
FIN Class 0-30 31-60 61-90 91-120 ...
April 20, 2011 at 8:50 am
Dan I have reposted the code and results but I will answer your question
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...
April 20, 2011 at 8:12 am
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...
April 5, 2011 at 6:49 am
I knew it was something simple. The left join gave me data back. Thanks...
April 1, 2011 at 12:31 pm
April 1, 2011 at 10:10 am
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...
October 20, 2010 at 12:14 pm
Thanks so much...that fixed it...I had a brain fart. Monday 😀
August 23, 2010 at 11:48 am