I really need someones help now I have ran out of ideas on how to do this.

Langley B SundayAverages:http://www.box.com/s/88xjepx4902vos0zjfec

The above database works, however I am trying to simplify the data entry by having the form look like a match score card

See word Doc:http://www.box.com/s/hpb086tjx553cram1hkz

Idealy I would like two data entry forms 1 for home games and 1 for away game results, as I will then create a query like I have in sunday averages to calculate Won lost played etc like a football league table. If this is not possible is there a work around if so please help.



pls view the above database and all tables and queries in design view you will then see how things are calculated.

A Guy Called Michael tried to help me with this database the data entry form on this database is what im looking for but i need to be able to calculate for matches home and matches away total games played won lost etc per player like the query in langley database.

If a Player score 21 at home they win and get 2 points
If a player scores 21 away they win and get 3 points
o points if they loose.

Michaels http://www.box.com/s/964am92r9t6dyvust5vu

Pls help.



Please feel free to create the table structure and relationships I can do the rest.