Updating 1500 records in a column with the click of a button?

[b31luv]

Can this be done?

Here is the twist. The records I am trying to update are all different and look like this A154, B982, C717, D559, Etc.

Here is how I am thinking.

If [Sample].SampleNum = A* Then
[Sample].SampleNumNew = * (Where as the * equals the remaining portion of the cell.)
Else
[Sample].SampleNumNew = [Sample].[SampleNum]
End If

I don't really want to type in all of the new numbers so any assistance will be greatly appreciated.

 

[jdegeorge]

Are you trying to remove the first character so that A154 ould become 154?

If so, you can run an update query:

UPDATE Table1 SET Table1.SampleNum = Right([SampleNum],Len([SampleNum])-1)
WHERE (((Left([SampleNum],1))="A&quot);

Or like this is you want to have the user enter the first character to remove:

UPDATE Table1 SET Table1.SampleNum = Right([SampleNum],Len([SampleNum])-1)
WHERE (((Left([SampleNum],1))=[Enter Prefix]));


Just insert your table name and field name.

Hope this helps.

Jim DeGeorge

 

[b31luv]

Man that worked like a charm, thanks.

 

[jdegeorge]

You're welcome. Glad to have helped.

Jim DeGeorge