-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Updating Table in Access
- Thread starter t406jaw
- Start date
He is some example data if it helps
Teams
1.Wirral Eagles
2.Upton JFC
3.Newton Athletic
4.Chrisleton New Scene
MatchDay Team 1 Team 2 Score
1 Wirral Eagles Upton JFC 2-1
1
Table would then read
Position Played Won Drawn Lost GF GA GD
1 1 1 0 0 2 1 +1
2
3
4 1 0 0 1 1 2 -1
Teams
1.Wirral Eagles
2.Upton JFC
3.Newton Athletic
4.Chrisleton New Scene
MatchDay Team 1 Team 2 Score
1 Wirral Eagles Upton JFC 2-1
1
Table would then read
Position Played Won Drawn Lost GF GA GD
1 1 1 0 0 2 1 +1
2
3
4 1 0 0 1 1 2 -1
Upvote
0
You could use an append query - update queries update the existing records. Both might be necessary depending on what exactly you are doing.
Technique could be to write new events to a temporary table until you click a form button, at which point it 1) adds it to the master table and 2) deletes it from the temporary table.
Mike
Technique could be to write new events to a temporary table until you click a form button, at which point it 1) adds it to the master table and 2) deletes it from the temporary table.
Code:
INSERT INTO tblName2 SELECT * FROM tblName1;Mike
Upvote
0
Similar threads
