Can I query the results of a query?

[LordJezo]

Like to somehow take the results of one query, store them in a table, and then take another query to query those results?

Or maybe ot store them in a table but somehow take results of query 1 and then run query 2 on them?

 

[dcx693]

Why do you need to store the results in a table? A select query is just a particular view of the data that already exists in your database.

 

[LordJezo]

Why do you need to store the results in a table? A select query is just a particular view of the data that already exists in your database.

Because I need to filter the data from the table in one way, and then filter it again a second time.

I figured that if I could store it in a table I could just write a second query to filter it again.

 

[Mile-O]

Waste of time.

Just base the second query off the first query.

 

[dcx693]

Waste of time.

Just base the second query off the first query.

Exactly.

A typical select query (not an action query) just lets you look at the data in your table(s) or queries in a different way. You can sort the date, filter it, calculate results from it, etc.... You can base queries on tables, and you can base queries on other queries. And you can base forms on queries or tables.