Hi

I wish to update the top X records in a table so that a YES/NO field is set to true.

I have figured out how to update all records:-

UPDATE tblList_Contractors SET tblList_Contractors.Selected = True;

I'm just stuck on the bit where I pick out the first X!

Many thanks
Lee