Hi All
I have a question.
I created 2 crosstab queries
1)Crosstab for number of logons per Customer per account per day.
Crosstab Format for Logons
--------------------------
CustID Acct# 1-Mar 2-Mar 3-Mar 4-Mar
001 1234 34 44 91 44
002 1989 9 8 77 98
003 9871 29 9 91 98
2) Crosstab for number of items sent per customer per account per day.
Crosstab Format for Items Sent
------------------------------
CustID Acct# 1-Mar 2-Mar 3-Mar 4-Mar
001 1234 3 4 9 48
002 1989 139 38 177 988
003 9871 3429 39 391 898
How to combine both the crosstab to get the final output something like this
001
1234 1-Mar 2-Mar 3-Mar 4-Mar
Logons 34 44 91 44
Items Sent 3 4 9 48
002
1989
Logons 9 8 77 98
Items Sent 139 38 177 988
003
9871
Logons 29 9 91 98
Items Sent 3429 39 391 898
Is this possible.
Thanks for all your help.
I have a question.
I created 2 crosstab queries
1)Crosstab for number of logons per Customer per account per day.
Crosstab Format for Logons
--------------------------
CustID Acct# 1-Mar 2-Mar 3-Mar 4-Mar
001 1234 34 44 91 44
002 1989 9 8 77 98
003 9871 29 9 91 98
2) Crosstab for number of items sent per customer per account per day.
Crosstab Format for Items Sent
------------------------------
CustID Acct# 1-Mar 2-Mar 3-Mar 4-Mar
001 1234 3 4 9 48
002 1989 139 38 177 988
003 9871 3429 39 391 898
How to combine both the crosstab to get the final output something like this
001
1234 1-Mar 2-Mar 3-Mar 4-Mar
Logons 34 44 91 44
Items Sent 3 4 9 48
002
1989
Logons 9 8 77 98
Items Sent 139 38 177 988
003
9871
Logons 29 9 91 98
Items Sent 3429 39 391 898
Is this possible.
Thanks for all your help.