R
RSteph
I've got a table with 5 columns and roughly 75 rows. In each of these fields
is a random number from 1-20. I'd like to get a count of how many of each
number exists, but within a single column; and overall through the 5 columns.
Does anyone know a good way to create a query that shows the numbers (1-20)
and then a count for each column and a "total count" column?
Any help would be greatly appreciated.
is a random number from 1-20. I'd like to get a count of how many of each
number exists, but within a single column; and overall through the 5 columns.
Does anyone know a good way to create a query that shows the numbers (1-20)
and then a count for each column and a "total count" column?
Any help would be greatly appreciated.