murray83
Games Collector
- Local time
- Today, 04:17
- Joined
- Mar 31, 2017
- Messages
- 728
OK so have a situation like so.
end of first of questions it displays the scores and then a query selects the team with highest score as shown in the attached image, but know i have an idea on how to move on and alter teams based on score, let me know if this would work or is daft, this is all back of the post it note ideas by the way
so
and then the same thing for when Team2, 3 or 4 are the high scoreres
or owuld it best to do just do it in sql with an update query
end of first of questions it displays the scores and then a query selects the team with highest score as shown in the attached image, but know i have an idea on how to move on and alter teams based on score, let me know if this would work or is daft, this is all back of the post it note ideas by the way
so
Code:
if txtTeamLeaving.Value ="Team 1" then
DoCmd.OpenQuery "UpdateTeam2" 'moves team 2 from team 2 table to team 1 table
DoCmd.OpenQuery "UpdateTeam3" 'moves team 3 from team 3 table to team 2 table
DoCmd.OpenQuery "UpdateTeam4" 'moves team 4 from team 4 table to team 3 table
else
end if
and then the same thing for when Team2, 3 or 4 are the high scoreres
or owuld it best to do just do it in sql with an update query