Solved CREATING A REPORT TO LOOK LIKE EXCEL SPREADSHEET (1 Viewer)

[I am alive]

Hello everyone. Please kindly assist me look at attached database and help me come up with a report which looks like excel spreadsheet as attached in the picture. Thanks in advance.

 

[Uncle Gizmo]

Why? --- Why not just export directly to excel?

 

[I am alive]

Why? --- Why not just export directly to excel?

Please show me how to come up with the report in ms access first. Please kindly

 

[arnelgp]

see qryGrades.
see report rptGrades and you need to adjust and Abbreviate the Labels
so it will fit in A4 paper.

 

[I am alive]

see qryGrades.
see report rptGrades and you need to adjust and Abbreviate the Labels
so it will fit in A4 paper.

Thank you so much. That is why I like this forum. Once again thank you so much. God bless you so much.

 

[I am alive]

see qryGrades.
see report rptGrades and you need to adjust and Abbreviate the Labels
so it will fit in A4 paper.

see qryGrades.
see report rptGrades and you need to adjust and Abbreviate the Labels
so it will fit in A4 paper.

I hope i am not asking too much. Thanks for going extra mile. I would wish to have average for those subjects. Once again thank you.

 

[arnelgp]

i created qryAvgMarks (see in design view).
then i add this query to the crosstab query, qryGrades.
next, add the Average field to the report.
view your report in Layout view.
if you pan to the right, you will see dotted line at the right.
that is the Limit of A4 in landscape view. so you must
adjust the textboxes so it will not go beyond the dotted line.

 

[I am alive]

i created qryAvgMarks (see in design view).
then i add this query to the crosstab query, qryGrades.
next, add the Average field to the report.
view your report in Layout view.
if you pan to the right, you will see dotted line at the right.
that is the Limit of A4 in landscape view. so you must
adjust the textboxes so it will not go beyond the dotted line.

This brings average of subjects scored by Students. I need average for subjects. When i click totals in home tap i am able to get. Now to transfer to report is a problem.

 

[I am alive]

i created qryAvgMarks (see in design view).
then i add this query to the crosstab query, qryGrades.
next, add the Average field to the report.
view your report in Layout view.
if you pan to the right, you will see dotted line at the right.
that is the Limit of A4 in landscape view. so you must
adjust the textboxes so it will not go beyond the dotted line.

I meant when I run qryGrades and click totals in home tap it gives me average for subjects. Exactly what I needed. How will I transfer to reports. I am still new in ms access but I am learning alot in this forum.

 

[I am alive]

I meant when I run qryGrades and click totals in home tap it gives me average for subjects. Exactly what I needed. How will I transfer to reports. I am still new in ms access but I am learning alot in this forum.

Home tab

 

[I am alive]

i created qryAvgMarks (see in design view).
then i add this query to the crosstab query, qryGrades.
next, add the Average field to the report.
view your report in Layout view.
if you pan to the right, you will see dotted line at the right.
that is the Limit of A4 in landscape view. so you must
adjust the textboxes so it will not go beyond the dotted line.

I have figured it out. Thank you so much. Kudos to the creator of this forum. God bless you

 

[I am alive]

@arnelgp thanks

 

[Pat Hartman]

Why is the column on the right a total rather than an average?

 

[I am alive]

@arnelgp used pivot