Slap
Registered User.
- Local time
- Today, 00:01
- Joined
- May 21, 2011
- Messages
- 45
I am trying to set up a database to store and report on a football score predictor game for friends.
In essence each week there will be 6 games for which each participant will predict the outcome (Home win, Away Win or Draw) with 1 point awarded for each correct selection.
Where I am running into a wall is on the form for the predictions, which I would like to be something similar to the attached .xlsx example for which I think I will need a subform in datasheet view but I am really unclear on how I would accomplish this and in need of some guidance please!
In the ACCDB file I have some test data:
qryCurrentMatchesNew is the list of this weeks 6 games, against which for each player in tblPlayers I would need to enter some values into the table tblPredictions (Match_ID, Player_ID, Prediction and Paid)
Thanks in advance.
Tony
In essence each week there will be 6 games for which each participant will predict the outcome (Home win, Away Win or Draw) with 1 point awarded for each correct selection.
Where I am running into a wall is on the form for the predictions, which I would like to be something similar to the attached .xlsx example for which I think I will need a subform in datasheet view but I am really unclear on how I would accomplish this and in need of some guidance please!
In the ACCDB file I have some test data:
qryCurrentMatchesNew is the list of this weeks 6 games, against which for each player in tblPlayers I would need to enter some values into the table tblPredictions (Match_ID, Player_ID, Prediction and Paid)
Thanks in advance.
Tony
