I recored the results so the query you will see in old db produces a player league table of which player is performing the best etc.
Write here goes, one last attempt at trying to explain what Im trying to do, I have a database that works but want to re-design it to do the the following
1. store and record match data, see below
Date of Home Home/away Game
Played at home - Yes No
Won H - yes/no
Lost H - yes/no
Points - 2 points 4 each player if they win at home
Played away - yes No field
Our score - if player reaches 21 they have won there game
Won Away Yes/no
Lost Away Yes/ No
Points Away 3 points 4 each player of they win away.
However in my 1st attempt at re-designing it with some help, how i want the data entry form to look is perfect but i do not now how to get the query i have in the 1st database t work in the 2nd, because the query in the 1st database relys on two sets of data to add up.
ideay i would like two data entry forms, for the home and away matches, put players that make up my sunday team is a total of 8 but the players names can very from match to match depending on who is avalible or who is performing. like many to many.
If anyone could help with either a design that they no will work or a query that will work then please feel free to have a go.
Link 1 and link to i have had to use box.com to upload even though i have cut the info down as much as i can.