Update N number of Records

[mjd1947]

Hi,

I want to have a command button that will prompt the user to update a specified number of records from the table. When clicked, a prompt will ask how many records and then update fields based on other controls. I have attempted this with the TOP function but cannot get the command to update only the TOP records returned.

Thanks in advance.

 

[1DMF]

What code do you have?

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music

 

[Andrzejek]

So there is a table with, let's say, 10 000 records. I click a button and I am asked: "How many records do you want to update?" I say: 15

Which 15 records out of 10 000 are being updated?

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[mjd1947]

It can be the first 15 records. Basically the 10,000 records would be a pool of open Product IDs and I want to select the first X amount to update. Does that make sense?

 

[Andrzejek]

You may try something like:
[tt]
Update SomeTable
Set SomeField = 1234
Where PKField IN ([blue]Select TOP 15 PKField
From SomeTable
Where some condition to put the records in order[/blue])
[/tt]

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

What Andy is trying to point out is that a table is an unordered relation, and the "first 15" mean nothing; like picking marbles out of a black sack with a blindfold on.

You must first put the set in some order before you can get the "first 15" with any meaning.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[mjd1947]

Got it. Thanks so much for the advice.

 

[SkipVought]

@mdj1947,

It's appropriate to thank a member for a [blue]Great post![/blue] using the link at the lower right-hand corner. This also help other members identify helpful post as they browse the threads posted in the forum.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}