Answer for:

MSFT Access - Using the Query more than once

Message 5 of 5

View entire thread
0 Votes

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?