Does anybody know how to use Microsoft Access

[WCE2000]

I've been given the job by my club of working out player statistics for the last 40 years.

Ive been looking at MS Access, but i don't know how to link the tables together.

IE, ive entered in the stats for 98/99 and 99/2000 (these are cricket stats). Now before i go on any further i want to work out how i can link the tables together.

For instance, Anthony Stuart took 20 wickets in 98/99 and 47 in 99/2000.
I want to have a table which has their overall averages, so for Anthony Stuart it would say 67 wickets.

Can somebody help me with linking the tables together please?????????

------------------
Join the big footy tipping competition at Footy Tips (http://www.footytips.com.au)
Join the BigFooty Cricket Cup (http://bigfootyca.topcities.com)
visit the Easts Cricket Club (http://www.eastscricket.com.au)
The ulitimate statistics reference (http://cromulent.freehosting.net/)

[Fred]

Excellent question wce2000. No idea what the answer is but liked the question.

[ptw]

yes...I know

send me an email if you like...

ptw

[teddy3]

Did a Computer subject on Access at Uni, still have NO IDEA what they were on about... sorry but I can't help you...

[Mobbenfuhrer]

Create a query based on both of the tables (choose one, then right click in the query to add the other add in), then go to 'build' with a right click from the criteria field of the stat you want, and choose each table/field, separate with a '+'. The create a report based on the query.

... or eMail myself or ptw :D

------------------
Hallowed be thy Roy