When I design an update query in Access, it limits me to the amount of information I can enter into the criteria area in the grid. Is there some way I can reference an external file or other method to be able to list more criteria for the update?
In other words, let's say I have 1,000 image names on a seperate list. These names are in a field called "images". I want to update all the image in my list to the name 123.gif. How can I place all the image names in the grid without needing to keep going back and revising the list?
Possibly more information can be entered into the sql view? Or maybe I could paste the image names in this example into another table and add that table to the update query and reference the names that way? Would that be a logical approach? If so, How would I structure myy update query in the grid?
Any help would be great!
In other words, let's say I have 1,000 image names on a seperate list. These names are in a field called "images". I want to update all the image in my list to the name 123.gif. How can I place all the image names in the grid without needing to keep going back and revising the list?
Possibly more information can be entered into the sql view? Or maybe I could paste the image names in this example into another table and add that table to the update query and reference the names that way? Would that be a logical approach? If so, How would I structure myy update query in the grid?
Any help would be great!
