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!

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

Update statement using top 10 1

Status
Not open for further replies.

vamoose

Programmer
Joined
Oct 16, 2005
Messages
320
Location
MX
I am using Access 2003 and I am having trouble with an update statement. I would like to update only the first top 10 records with new data and I am not sure how to do this using the update statement with set and top 10.

Any ideas are greatly appreciated, thank you
 
UPDATE [SELECT TOP 10 Tablename.*
FROM Tablename]. AS a SET a.xxx= " A.yyy = "ggg";
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top