ACCESS- RELATIONSHIP 2

[Kathrynlewis]

I have 157,000 records in an Access database.
And I need one field of information to be consistant.
i.e If I have the name: GAP in 5 records and GAP Inc. on 1 record, and GAP USA on 2 records, How do I make the Gap Inc. and Gap USA = to GAP? Is there a simple way to find all the GAP and fix it in bulk- rather than import it into an excel spreasheet and do it manuallY? All other fields are not consistent. Please help ASAP. Thanks for anyone's suggestions

 

[benjamenus]

try

update [TABLENAME]
set [TABLENAME].[COLUMNNAME]="GAP"
where [TABLENAME].[COLUMNNAME] like "*GAP*"

 

[fneily]

In Datasheet view for your table, do a Find and Replace using the wildcards mentioned in the previous message.