M
March
Hello,
I would like to know how to combine multiple queries in crosstab table.
For example,
query1: listed
Field1 qty
A 8
B 3
C 2
D 5
query2: listed
Field1 qty
A 20
B 23
C 42
D 58
E 88
Z 89
From query1 and query2, I would like to have a result below
Field1 xqty mqty
A 8 20
B 3 23
C 2 42
D 5 58
E 88
Z 89
then I will take this to add into report view.
Thank you,
March
I would like to know how to combine multiple queries in crosstab table.
For example,
query1: listed
Field1 qty
A 8
B 3
C 2
D 5
query2: listed
Field1 qty
A 20
B 23
C 42
D 58
E 88
Z 89
From query1 and query2, I would like to have a result below
Field1 xqty mqty
A 8 20
B 3 23
C 2 42
D 5 58
E 88
Z 89
then I will take this to add into report view.
Thank you,
March