Thnaks so much. It works .

Regards

Thanks so much Hall of Fame for your help.

Is it neccessary to add an index on a key column, or foreign key column. Are there any performance related issues.

Its not homework nor is it an interview. am just trying to make my tables more effiecient and struggling with the first question, i know i can use a case,...

@SSCrazy

thansk it worked, and thanks to all you guys you helped me.

thansk unfortunately i dint want to use cursors. thanks for your help, i appreciate it.

hi

in the textbox go to properties and choose the format tab, next to format code: the is a button with ..., click it and choose percentage, your value might have...

Soory for the late reply

to fix the problem you insert the table in a rectange(which inturn is in a rectangle). so your table is inside two rectangles. you then insert...

I have fixed thiis problem so please ignore

I have managed to set the visible property. It worked after i added the filter option, my problem now is that i was counting totals, sums, and a lot more...

I DIDNT KNOW THAT,

Thank you very much.

Thank you very much Ramesh

thanks very much Vikas

i thought its possible to group, and return some usefull infromation as well.

Thank you very much fro your help

Thank you very much for your help, I have added an extra column to count the rows per subsection but it returns ones only

SELECTCount(S.SubSectionTitle) Mycount,S.SubSectionTitle,A.SubsectionID,A.QuestionID, A.ResultValue

FROMAuditResults A

INNER JOIN SubSection...

That was the problem ,

thank you very much.