delete function

[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.

 

[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.

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

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

 

[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.

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

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

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

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