fredElliotRules
Registered User.
- Local time
- Today, 02:39
- Joined
- Nov 3, 2006
- Messages
- 15
Hello,
I wish to create a query to produce statistics on two data groups 'A' and 'B'.
The query counts the number of people refered in every month (Using GroupBy). I would like to do a frequency count of both 'A' and 'B'. Is this possible using one query.
The referal date is a field in the table as is A and B.
SELECT [18-24].Month, [18-24].[CountOfAge Group], [25+].[CountOfAge Group]
FROM [18-24] LEFT JOIN [25+] ON [18-24].Month = [25+].Month;
This sort of produces what I want but I want all records to be displayed not just the ones in [18-24]
I wish to create a query to produce statistics on two data groups 'A' and 'B'.
The query counts the number of people refered in every month (Using GroupBy). I would like to do a frequency count of both 'A' and 'B'. Is this possible using one query.
The referal date is a field in the table as is A and B.
SELECT [18-24].Month, [18-24].[CountOfAge Group], [25+].[CountOfAge Group]
FROM [18-24] LEFT JOIN [25+] ON [18-24].Month = [25+].Month;
This sort of produces what I want but I want all records to be displayed not just the ones in [18-24]
Last edited:
