First off, I am using Access 2002.
I have a data set, and i am trying to Group By certain demographic files in my db (q59 as Sex1, in this example). Here is the code I have so far:
select 2 as QID, 1 as RID, "Yes" as QText, count(Q2) as Result, Avg(Q59) as Sex1
from sheet1
where Q2 = 1
group...