Solved AUTOMATICALLY GENERATE REPORTS BASED ON MARKS ENTERED.

[mercystone]

Hi. Have a look at the attached database. Check on rptStudentsGrades. Kindly assist me to change it(rptStudentsGrades) to column.(spreadsheet)
Please the user to enter marks and able to see reports horizontally not vertically. Thanks.

 

[Ranman256]

create a Crosstab query to view data horizontally.

 

[mercystone]

create a Crosstab query to view data horizontally.

Show me please

 

[arnelgp]

your db is same here?
Solved - CREATING A REPORT TO LOOK LIKE EXCEL SPREADSHEET | Access World Forums (access-programmers.co.uk)