[kapetang]

Καλησπέρα

Πάνο, χρησιμοποίησε το βοηθητικό ερώτημα ένωσης:

SELECT Table1.TA as A FROM Table1
UNION 
SELECT Table1.TB as A FROM Table1;

και το τελικό:

SELECT qryHLP.A, DCount("[R]","[Table1]","[R]='1'") AS 1, DCount("[R]","[Table1]","[R]='X'") AS X, 
DCount("[R]","[Table1]","[R]='2'") AS 2 FROM qryHLP;

Φιλικά/Γιώργος