Is it possible using a single Crosstab query?

T

Tim

Hi

Can anyone tell me if it is possible to create an APPEND query from a
CROSSTAB query in a single SQL statement?

I have a Crosstab query designed. I have another query that then takes the
recordset from this and appends the data into a table. That works fine.
But I really would like to be able to achieve this in a single step and
using code.

Any suggestions?

Many thanks for any assistance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is it possible to get Access to ignore not recognizing a field nameusing some sort of error handling 1
Form based on crosstab query 1
Create table from a crosstab query 2
Crosstab query 1
Crosstab Date Range in Reports 3
crosstab query problem 7
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Office 10 Crosstab query with Parameters 0

Top