Use a query for a query, newbie question

[jal]

Newbie question: In datasheet view, I don't see an option to save the data as a table (so I can use the table for other operations).

For example, if I create a query in design view, the "Save" option only seems to save the query-syntax, not the actual data. So I end up having to first export the data to Excel and then import it as a table. Seems kind of silly the idea of having to rely on a spreadsheet to build a database table. Can't I use the database to build a databae table?

On a related note, I had hoped to use one query as a "database object" accessible from a second query. What I mean is, having saved Query1, I wanted to write: SELECT FROM Query1 Where... but I got an error when I tried this.

 

[BrettStah]

You can change your query from the default "select" query to a "make table" query. But you can simply base the second query directly on the first query. When you create the second query, you should see the dialog box where you can choose from a list of tables to base your query on - you should see a "Queries" tab on the dialog box, and you can choose from your list of queries right there.

 

[jal]

Thank you so much

Thanks so much. I meant to thank you earlier but was too bogged down with my project. Your information not only helped me finish my report but also helped me develop a macro to automate the report.