Worked it out another way!
Thanks for your help with that problem.
I kept getting an error with the code you suggested so a I tried another million combinations. And at last, one came out good!
SELECT creator AS XLABEL, COUNT(lessontitle) AS YVALUE FROM (SELECT DISTINCT creator, lessontitle FROM lomaster) GROUP BY creator
I'm not really sure how it works. I hope to get some procedural tact in SQL.
Thank you for looking at it for me.
Cheers
J