Report hassle!!!!!!!!!

[bronwyn]

Hi there, I have a very basic dbase which includes the following tables:

Courses
course number text 4 chars PK
course name Text 35 char

Students
Mat Number text 4 chars PK
name text 25 chars
address text 40 chars
dob date
course number text 4 chars

Modules
module number text 4 chars PK
module name text 30
cost currency
credit text 2 chars

Student/Modules
Mat Number text 4 PK
Module Number text 4 PK
result text 6 chars

what i am trying to do is create a report showing student name, module name, credit and result. the records are to be grouped on student name with subtotals for each group on credit, which is built as a text field but could be a number ie 1, 2, 3 etc.

the problem that i seem to be getting is that when i run the report, i get subtotals for each module as opposed to a subtotal for each individual matriculation number. any help or ideas would be greatly appreciated, thanks in advance

bronny

 

[BrianB]

If your data is in a simple table with row 1 column headings and data underneath then pivot tables will enable you to cut the data however you wish.

 

[Andrew Fergus]

Hi Bronny

If you go into your report design, Click View -> Sorting and Grouping, what are the current settings? I'm a little confused but I think you were asking for subtotals by student (and I think a student = matriculation number) so what you should see is grouping and sorting by student name.

At the moment it may show grouping by module number under the heading "field/expression" - if this is the case then you need to either delete that entry (in the sorting and grouping screen) or change it to student name. In the group properties part of the screen, make sure the group footer is set to yes and if you want to keep all of the students module results together on the same page, then set the "keep together" field to "yes".

Back in the report design, you then need to set up the subtotal in the student name footer section of the report. Post back here if you need help with this bit.

HTH, Andrew.