Software

Ask something
Discussion Locked

Access field merge

0 helpful
3 replies

by techgirl75

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Okay, here is my question. I have an existing access database. There are several fields in a from..in the fields we have a drop-down list of records to choose from for several of them. My question is: after reviewing these records we see that there are several that are duplicates just with a slight name change and so they were never caught. I know i can delete a "form record" with no problem but a "field record".. will cause me problems in every instance it is used previous to the deletion. Help!!

3 replies

by churdoo

I suggest you do an update query on the underlying table to look for and update all variations of the field to a standard value. Once you do the update query, then you can eliminate the various entries in the drop-downs.
The query design tools arefairly good, but when you do the update portion, be careful. In fact, a good technique will be to make a copy of the database to a stage directory and design the queries there. Once you've got it down, you can copy the queries to the production system and make the changes in production.
--Charlie

This discussion is closed to new replies.