I've got a table set up like this:
TransID(key), MemberID, TransType, Timestamp
What I'd like to do is create a query that would count the number of unique MemberIDs for each TransType and display by month. Like this:
I'm not entirely sure where I'd even get started on this one.
TransID(key), MemberID, TransType, Timestamp
What I'd like to do is create a query that would count the number of unique MemberIDs for each TransType and display by month. Like this:
Code:
|Jan |Feb |Mar |
---------------------------
TransType1 | ## | ## | ## |
TransType2 | ## | ## | ## |
TransType3 | ## | ## | ## |
I'm not entirely sure where I'd even get started on this one.