Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Crosstab Query
4 views
Skip to first unread message
MJones
Nov 7, 2011, 9:36:42 AM11/7/11
to
Hi All,
I hope someone can help; might need a crosstab query.
A report by ReferrerType by Year is needed, e.g.
2010 Marketing Report (how clients found us)
Business Associate 12
Previous Student 36
Brochure 8
Website 45
Total 2010 Referrals 101
tClient table has fields ReferrerType and ID (unique for each client)
tClassClient table has ClientID (matches ID above) and ClassCode
ClassCode determines year, e.g. Like “10*” shows it’s a 2010 class,
“09*”, etc.
I can get a report without year or without total by ReferrerType, but
not both.
After struggling for 3 days, any hints are very much appreciated.
Thanks,
Michele
I hope someone can help; might need a crosstab query.
A report by ReferrerType by Year is needed, e.g.
2010 Marketing Report (how clients found us)
Business Associate 12
Previous Student 36
Brochure 8
Website 45
Total 2010 Referrals 101
tClient table has fields ReferrerType and ID (unique for each client)
tClassClient table has ClientID (matches ID above) and ClassCode
ClassCode determines year, e.g. Like “10*” shows it’s a 2010 class,
“09*”, etc.
I can get a report without year or without total by ReferrerType, but
not both.
After struggling for 3 days, any hints are very much appreciated.
Thanks,
Michele
0 new messages