Tallying Numbers in my Query

[hammy69]

I have got a big data base (40mb) and i am currently trying to run a query which i need help with.

In my database i different parts which are graded by levels e.g.

Part Level

Nut 2
Bolt 1
Pipe 2

In my query i want to run it so that i will have column headings e.g.

Level 1 Level 2 Level 3

and under each heading there will be a total of the number of parts under each level e.g. under level 1 there will be a one, under level 2 there will a 2 sourcing from the above data example.

Please help!!

 

[ThreeCrow]

Do you need to view this in a Form (on screen) or as a Report or in Query DataSheet?

 

[hammy69]

Query Datasheet please

 

[Rich]

Use a crosstab query

 

[Murli]

But the crosstab query needs a minimum of three fields. Wat do you say?