Append crosstab result to a table

G

Guest

have following data:
1234 fred client
1234 tom owner
1235 ralph client
1235 bill owner
crosstab query result:
1234 fred tom
1235 ralph bill
I want to append this data to an existing table with fields:
number,client,owner

Making an append query from the crosstab query does not seem to work...

Any thoughts?
 
G

Guest

Duane,
Thanks. The keyword is SAVED, isn't it. Like a real dummy I was trying to
modify the crosstab query by changing its type, instead of specifying it as
the source in a select query then modifying that to an append type. And I
almost had the entire procedure modeled in vbasic with DAO recordsets.....
 

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

Select duplicate items in a query 1
where statement 2
Concatenate Question 2
return comma separated list 2
Date order in a crosstab query 2
Update Query To Append Text To A Field 2
Query a crosstab query 2
Access 2000 append unbound text box values to a table 0

Top