Crosstab Query

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top