Edit Lookup Column

[jparks2010]

Hey all I have a spelling error in my lookup column. So I would like to change the spelling and have it automatically correct the spelling on all the records with the misspelled value. I am using Access 2007. Suggestions anybody!!

 

[JamesMcS]

Use an update query to update to the correct spelling, criteria would be the wrongly spelled word.

 

[jparks2010]

thanks I got it spelled correctly and all the records updated to reflect the new spelling

 

[JamesMcS]

Excellent, glad it worked!