delete function

J

John

I have a field with EID:12345678 in it I'd like to take out the EID: in all
rows. I know I did this years ago but forgot how. Could someone please help.
Thanks.
 
F

fredg

I have a field with EID:12345678 in it I'd like to take out the EID: in all
rows. I know I did this years ago but forgot how. Could someone please help.
Thanks.
Click to expand...

Permanently?
Back up your table first.
Run an update query.

Update YourTable Set YourTable.FieldName = Mid([Fieldname],5) Where
Left(FieldName,4) = "EID:";
 
F

fredg

I have a field with EID:12345678 in it I'd like to take out the EID: in all
rows. I know I did this years ago but forgot how. Could someone please help.
Thanks.
Click to expand...

Permanently?
Back up your table first.
Run an update query.

Update YourTable Set YourTable.FieldName = Mid([Fieldname],5) Where
Left(FieldName,4) = "EID:";
Click to expand...

I meant to add...
You can also use the replace function:

Update YourTable Set YourTable.FieldName =
Replace([Fieldname],"EID:","");
 
Top