M
MJones
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