BlueRhinos
Board Regular
- Joined
- Aug 31, 2007
- Messages
- 83
Systematically, I have a prebuilt query that needs updated with the most current data table. In my process, I add the new table to the query and then update each static field with the new table. While the update only takes a couple minutes, it's cumbersome because the query contains lots of fields. I can't use the asterik for all fields, as there are certain fields I need to exclude. Additionally, I don't the computing power to link the my access table to an external excel file. Is there a shortcut that would more efficiently update all fields in the query to reflect the current table? Thanks! -db