standards field data in ms access

route217
route217 used Ask the Experts™
on
Hi Experts

I have a field in my table (source) data where some of the same data fields are keyed in slightly differenetly....how do i standards the names in the table...

so Field "Status" has

1. LMA1* and LMA1
2. Telephone2* and Telephone2

I want to remove the * from the data and only show Telephone 2 and LMA1...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Nerd
Most Valuable Expert 2012
Top Expert 2013
Commented:
You could run an UPDATE query:

UPDATE Status
SET Status = Replace(Status,"*","")

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial