Hello Ramesh,

How are you doing? I was sick couple days because the flu season in the US. :hehe: Thanks for the respond back to me,

I have a question for you...

Hello Ramesh,

How are you doing? Sorry to bother you Ramesh, are you ok? Did I make you mad about the way I ask you questions which relate to SQL? Because...

Hello GSquared,

Thank you for your lessons, wish you and your family have a wonderful weekend.

again, Thank you very much

Hello GSquared,

If I run the code in New query like you told me in order to avoid the codes are changing to something else. So if I run in New...

Hello GSquared,

Thank you very much for your efforts to help me solve the problems.

So if I use new query then I can avoid the codes are changing to some...

Hello GSquared,

This is what I do to have the total at the bottom of each column. But I don't know, Is this a right way to do? If it is...

Hello Steve Jones,

How are you doing? Thank you for your reply, how can I do it on the front end? Would you please tell me how?

Thank you Steve,

Very Respectful

Hello GSquared,

I typed exactly what you suggest me to do then it gives me a message:

"Column dbo.ALLCASESCLEARED.CLEAREDDATE is invalid in the select list because it is not contained in...

Hello GSquared,

THank you very much for your helps...I'm greatly appreciated your helps.

Again, Thank you so much

Very Respectful

Hello Grant Fritchey,

Below are the codes that I wrote but when it displays the report it wasn't display the total number at the bottom of each column. So that why...

Hello Lynn Pettis,

I have already apoloziged to that person. If I know what I am doing then I won't bother anyone here. I am at the learning to be like...

Hello Grant Fritchey,

I have 4 tables such as BOCLEARED, CTCLEARED, NHCLEARED, and TOTALCLEARED.

In table BOCLEARED (given), it includes 3 columns such as

DDS BOCLEARED ...

Hello bvaljalo

First, I apolozige for not knowing your name because I am new to this SQL.

I did change the field name and it still says that dbo.BOCLEARED is...

Hello Grasshopper,

How are you doing?

I type the code that you told me and it works the first part:

Use [Regional Office Claims Adjudication Process-Disability (ROCAP)];

If Object_ID('GRANDTOTAL') IS NOT NULL DROP TABLE...

How are you doing? Thank you for your responds, the reason I used the FULL Join because I join the CLEAREDDATE of each table to CLEAREDATE of the "ALLCASESCLEARED" where...