How to calculate?

[cap.zadi]

Hey,

I have table with following information:

tblEmpSMInfo (100 emp list)

EmpID (ID)
EmpName (Name)
SSize (Shoe Size like 41,42,43)
SType (Normal, Low Cut, Long)
SGNormal (Safety Golves Normal) Yes/No
SGSpecial
SMNormal
SMSpecial
EarPlug


when we select a employee so we assign the shoe size he have and type of shoe as per designation. then check box either he need those Saftey materials or not.

so how to calculate from this in a query:



Size wise total qty?
By Type QTY?
How many normal golves we required? (calculate from check box)


so please advise?

thanks

zee

[alansidman]

Try this

SELECT tblEmpSMInfo.SMNormal, Count(tblEmpSMInfo.SMNormal) AS CountOfSMNormal
FROM tblEmpSMInfo
GROUP BY tblEmpSMInfo.SMNormal;