Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Append query

Status
Not open for further replies.
ScottWood

ScottWood

Technical User
May 31, 2001
81
GB
I have created an append query that adds records to a table what i would like it to do though is add the figures to existing records, can anybody help me do this.
 
Sort by date Sort by votes
look into the UPDATE command --

UPDATE tableName SET columnName = value WHERE column = criteria

good luck! :)
Paul Prewett
penny.gif
penny.gif
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

serino
  • Question
Help with a Query. 1
Replies
13
Views
414
strongm
strongm
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
701
Andrzejek
Andrzejek
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
390
monkeysee
monkeysee
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
757
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top