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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Impromptu Crosstab help

Status
Not open for further replies.

Swathi37

Vendor
Dec 23, 2002
77
US
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top