Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crosstab queries --appending results
- Thread starter jgarnick
- Start date
You can create a crosstab query, and then create a new query (which uses the crosstab just created) and save the 2nd query as an append query. i haven't tried it, but i'm pretty sure it will work, it will probably just take the use of two queries (or some code). <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
Access does allow you to do a conversion under the Query Menu on the toolbar, but of course the visual layout of a pivot table is different than that of a regular table. I just tried creating a table by converting a crosstab to a make table, then appended by converting the same table to an append, and selecting theat new table to append to. It worked, and gave me duplicate values. Is this what you meant?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question