append query field

A

arun

How to append all crosstab-query field (sum month data) to another crosstab-query in macro or VB

first crosstab-query
MonthName(Format([Date_Ship],"m")), ItemCode, Sum([QTY]
column heading, row heading, valu

append to this crosstab-query
Date_Ship ItemCode, total:Sum([QTY]) QT
column heading, row heading, row heading, valu
 

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

Append Crosstab Query to Existing Table 0
Crosstab column data count 6
Crosstab By Date (Month) 5
Too many fields defined 1
Query a crosstab query 2
Totalling Rows and Columns in a Crosstab Query 1
Crosstab query and Lookup field problem 3
update crosstab 0

Top