I have multiple tables open for a query, all with the same format (log data for various runs of a process). Is there an easy way to have a query pull ALL of the results of a particular column/parameter? For example, I want to create a table that has every "Power" column from all of the tables I am looking at.
Thanks
It sounds to me like you need a separate APPEND query for each table that you are retrieving data from. If you pull data from more than one table with one query, you need a field from each table to join, and your results of the query will be dependant upon that join.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks