Web Development
Is it possible to run a query and then run a 2nd query without having Access paste the 2nd queries data over the 1st queries data?
Currently have a huge table and need to compare query data side by side, i.e. look at both sets of data at the same time.
by reitern Accepted solution
by deity_chooch Accepted solution
by jbwilson1120 Accepted solution
When you say run a query, do you mean run an action query (delete, update, append, etc.) or a select query?
If you want to compare two select queries, you can create a new query and include both queries as source queries. Make sure to join them together on the primary key. You can left or right join them to see if one query has records the other doesn't. If you use inner join, you only get the records that both queries return.
by reitern Accepted solution
Running a query = Running a select query.
An example might help, imagine a table and in the first column is a list of the 50 states while the first row lists the last 10 years (1999, 2000...2009) with data populated for each state and year.
How can you run a query to select a state(California) and see its data and then run a query for another state (Montana) and see its data without losing California's data?
by tony hopkinson Accepted solution
dual monitors would probably help.
This discussion is closed to new replies.
Sort by Trending