Count in a field

[LG]

I need to run a query to find out how many of each type is listed.
If I have R1. R2, and R3 are the fields, R1 always has to have a number of
1-87 and R2 and R3 may have 0 or any 1-87 as well. I am running a query to
find out how many of each number (1-87) exists in each of the fields. Do I
have to run 2 queries to find out how many #1 are in R1, 1 as regular query
and the other as a count and then join them?

 

[KARL DEWEY]

Try this --
SELECT [R1], Count([R1]) AS Count_R1, [R2], Count([R2]) AS Count_R2, [R3],
Count([R3]) AS Count_R3
FROM YourTable
GROUP BY [R1], [R2], [R3];