No subject
Wed Dec 28 11:38:03 CST 2011
The Count of queries:
qryCountOfType1...
SELECT qryTypes1.Type, Count(qryTypes1.Type) AS CountOfType
FROM qryTypes1
GROUP BY qryTypes1.Type;
qryCountOfType2...
SELECT qryTypes2.Type, Count(qryTypes2.Type) AS CountOfType
FROM qryTypes2
GROUP BY qryTypes2.Type;
Finally a Union query with an extra field to sort by the two types of groups.
The Union query
SELECT '1' as SortOrder, *
FROM qryCountOfType1
UNION SELECT '2' as SortOrder, *
More information about the AccessD mailing list