Thanks for your reply, I have attemped to design a report that looks like Excel. I have a main report which has two sub reports with 10 columns. Patient chart numbers display vertically across one subreport and the Yes,No or N/A results are lined down the second subreport. The main report has the Questions. I will need the result of each patient chart totaled. By the way, each question is worth a different amount of points... I included points fields in my table and set the default value for each question (seemed like a good idea) however I did not include a field to store the actual points based on the answer. I am self taught and right now my report card don't look so good. Thanks again for your time.