can it be done

[itsglitzy]

Hi im a newbie to access i have a column with entries in it
what im looking for is, lets say everything NI* and when it finds all that is NI001, NI98 etc etc it changes the NI* entries to FIN my column is called Region, thanks to all who post and i hope you can help

 

[itsglitzy]

Region FIN: IIf([Region]="NI*","FIN",[Region])

tried this but doesnt work

 

[Rich]

Look up the Like operator

 

[ColinEssex]

Won't an Update query do this?

Col

 

[The_Doc_Man]

An update query would do this but the trick is formulating the replacement.

In the update query grid, in the field having this NInnnnnn stuff (call it XYZ),

Field: XYZ
Criteria: Like "NI*"
Update To: "FIN" & Right( XYZ, 2 )

or maybe that is Right( XYZ, 3 ) - I always get the count confused as to what the RIGHT function keeps, unlike the LEFT function. Play with it.