I have a table with customer info. In the table is a field that uses a lookup table for the store the customer shops at. Some of these fields are null. I need to update them with the proper store name. I did a query with the city field and the store field. In the criteria for the city, I selected one city and in the store field I set it as null.
When I try to do an update query on the store field I get an error. There are over 2000 records that need to be updated, too many to do manually. Any suggestions?
Thanks in advance.
When I try to do an update query on the store field I get an error. There are over 2000 records that need to be updated, too many to do manually. Any suggestions?
Thanks in advance.