Simple Q on multiple queries

[prodata]

I'm used to doing a data analysis but never had much cause to use Access previously so I'm trying to quickly pick up the essentials for a specific work project:

I need to extract a subset of data from an Access 2000 database and then perform some category operations on that subset - all interactively. So 2 questions please:

1. I'd prefer to do this with two successive queries (just so the logic is plainer to me) the second operating on the results of the first. But I can't immediately see how to submit the results of one query to a second query interactively.

2. If I were to combine both queries into one can I safely assume that the columns will be processed from left to right (as shown in the query designer)? To explain: I want first of all to select a subset of the data and then to do some stats (ie as a 'total' field) on the subset. But I need to ensure that the stats are done on the subset and not the full original table.

TIA
John Dann

 

[RV]

John,

you can use a saved query in another query.
You'll have to join your saved query with another table in your main query though.
Queries are not processed from left to right.
In fact, which column you put first doesn't make any difference.

RV

 

[prodata]

Queries are not processed from left to right.
In fact, which column you put first doesn't make any difference.

Many thanks for the prompt reply. OK, sorry if I'm being thick here but how then should I proceed if I want to:

1. Create a subset of records from a table, then:

2. Calculate some stats - let's say group means - on the subset (which may be very different from the equivalent stats on all of the records in the table).

 

[RV]

You can create a query to do your subsets.
You can either do your cals in the query itself, in a new query based on your first query, in a new query that joins your first query with your table.

Depends on what you want, so try and see what best fit your requirements.

RV