querying a number data type

[Guest]

I have a table which has several number fields using mainly 1, 2 and 3. I
want to make a query whereby I can show there was for example 4 1's, 6 2's
and so on, in each field. Is this possible, if so could someone please tell
me how to make up the query. If not could someone tell me the query to tell
me how many 2 occurred in the one field.

Thanks in advance to any advice given.

 

[Jeff Boyce]

Take a look at the "Totals" query in Access.

If you "GroupBy" a field, then "Count" the number of records, you'll get a
count of 1's, 2's, ...

Now, if you have "several ... fields" that have this same range of values,
it sounds more like a spreadsheet than a relational database. Why are you
using Access to do this?

Is this a "questionnaire/survey"-related table? There are (other)
approaches to data structure that make it easier to use Access' features and
functions.

Regards

Jeff Boyce
Microsoft Office/Access MVP