No subject


Thu Dec 29 09:38:12 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