find record & rename record

G

George

Hi,
I want to run a macro that opens a table and locates all the records that
contain "SEEK" in the table and replace SEEK with SEK - is this possible?
I can only find renames for table or query names?
Thanks
George
 
S

Steve Schapel

George,

This is a job for an Update Query. Update the field(s) in question to...
Replace([NameOfField],"SEEK","SEK")
 
G

George

Thanks Steve - much appreciated

Steve Schapel said:
George,

This is a job for an Update Query. Update the field(s) in question to...
Replace([NameOfField],"SEEK","SEK")

--
Steve Schapel, Microsoft Access MVP
Hi,
I want to run a macro that opens a table and locates all the records that
contain "SEEK" in the table and replace SEEK with SEK - is this possible?
I can only find renames for table or query names?
Thanks
George
Click to expand...
Click to expand...
 
Top