Calc

[hitman]

candiates	day 1 sg count	day 2 sg count	day 3 sg count	day 4 sg count	day 5 sg count	total	average	max count	Rank
D. Kumar	204	211	226	223	256
A.Chowdhury	211	241	254	263	246
S.Ghosh	246	246	251	256	244
A.Das	245	264	251	256	258
J.Sen	236	234	238	245	256

sir i am completely new to access,i just want to know that in the following attachment how to calculate TOTAL AVERAGE MAX and RANK of the candidates from the table above.please give me solution using sql querries and tell me about how i can view it in ms access window

also i will request seniors to give me some links of good sites for learning ms access.

thanx in advance

[abusaif]

I guess you should look for Crosstab query.
and for the link try out this. www.funtionx.com

[alansidman]

Firstly, your table is not normalized. Please read this white paper on databases and designing them.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

Now to your specific question. Once your table is normalized, you can run aggregate queries to get that information. Here is a link on aggregate queries.

http://www.techonthenet.com/access/queries/index.php Scroll down to the Group By Features.

Here is a good tutorial to get you started once you have read the first link

http://www.accessmvp.com/strive4peace/