Report Counting Values from two fields

[doddy88]

Hi,

I'm trying to create a report using the field Course and the Field Status, where it coulds all the values. The two fields have values such as:

Course: Business Management, Business Studies, Marketing etc.

Status: Placed, Seeking Placement, Failed, Straight Through.

I would like a report that tells me how many people from Business Management have been placed, how many from business studies have been placed, how many from business management are seeeking placement etc.

So the report would look something like this:

Placed Seeking Placement Failed Straight T.
Business Management 27 12 4 2
Business Studies 17 9 2 6
Marketing 44 22 8 5

Any Ideas how to produce this report. Course is in tblStudents and Status is in tblPlacements which are linked with a one to many.

 

[Trevor G]

Easiest way to give a solution is to create a query based on the 2 tables then select the fields you want and then look to use Totals which will add groupings, so you can then set an additional field to count based on the field you want it to count.