I would like to have a report printed like this:
Quarter1 Quarter1 Quarter2 Quarter2 Quarter3 Quarter3 Quarter4 Quarter4 Running total Running total FamilyName FirstName StaffID Reading1 Reading2 Reading1 Reading2 Reading1 Reading2 Reading1 Reading2 Reading1 Reading2 Smith Fred 123456 0.2 0.3 0.2 0.3 0.2 0.3 0.6 0.9 Black Dave 234567 0.1 0.1 0.3 0.2 0.1 0.1 0.1 0.1 0.6 0.5 Porter Steve 345678 0.2 0.2 0.1 0.1 0.2 0.2 0.2 0.2 0.7 0.7
I have a table that has the data like this:
FamilyName FirstName StaffID Reading1 Reading2 YEAR QUARTER Smith Fred 123456 0.2 0.3 2015 1 Black Dave 234567 0.1 0.1 2015 1 Porter Steve 345678 0.2 0.2 2015 1 Smith Fred 123456 2015 2 Black Dave 234567 0.3 0.2 2015 2 Porter Steve 345678 0.1 0.1 2015 2 Smith Fred 123456 0.2 0.3 2015 3 Black Dave 234567 0.1 0.1 2015 3 Porter Steve 345678 0.2 0.2 2015 3 Smith Fred 123456 0.2 0.3 2015 4 Black Dave 234567 0.1 0.1 2015 4 Porter Steve 345678 0.2 0.2 2015 4
There is sometimes data missing from some quarters. I want the persons readings to show up on the report even if readings are missing. Is it possible to do this with the table I have? By the way the persons names are stored in a separate table linked by the StaffID.