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
 
Top