Need Held how to produce this output on my report

[adamskies]

Need help i want a report that would look like this please help

Shift	StaffName	Delivery	Dubbing	Playout
0600	Andrew	3	2	1
1100	Ragupathi		1	1
1400	Joseph	2
2200	Zarfan	4	2
		9	5	2

and my query form looks like this

JobNo Shift StaffName Delivery Dubbing Playout 77 0600 Andrew Baseband 78 0600 Andrew Baseband 79 0600 Andrew ToEdit 80 0600 Andrew Tape2Tape 81 0600 Andrew Mac2Tape 82 0600 Andrew Tape/Formats 83 1100 Ragupathi Tape2Tape 84 1100 Ragupathi ToEdit 87 1400 Joseph In-House 88 1400 Joseph Internet/Qlink 90 2200 Zarfan Back-up 91 2200 Zarfan Export 92 2200 Zarfan Baseband 93 2200 Zarfan Tape/Formats 94 2200 Zarfan In-House 95 2200 Zarfan In-House

[ranman256]

Use the query wizard and build a count qry
it will ask you how you want it laid out.
grouping and counting

[June7]

Count query would be an aggregate (GROUP BY) Totals query. Click the Totals button on ribbon and set parameters in the Totals row. Result like:

SELECT Shift, StaffName, Count(Delivery) AS CountOfDelivery, Count(Dubbing) AS CountOfDubbing, Count(Playout) AS CountOfPlayout
FROM tablename
GROUP BY Shift, StaffName;