help with frequency counts in several fields

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,
I have a table with 5 fields containing random numbers as values (sort of
like the lotto). is there a way to have a query to show the frequency of the
values of each fields?
e.g.
field1 field2 field3 ...
1 5000 70
2 2 70
1 5000 80
100 444 800

1 count 2
2 count 1
100 count 1
5000 count 2
2 count 1
444 count 1...

Thanks,

.

Relevant Pages

  • Re: Need SQL optimization help
    ... what sort of data each of the three tables ... contains (create table and create index statements for the tables are ... achive with the query etc ... ... Prev by Date: ...
    (comp.databases.oracle.misc)
  • Disabling the personal Workbook?
    ... query the database for information, then sort the data, and email it to ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Sort table, not with SQL!
    ... I found a solution to sorting a table! ... Create a query that will sort the table as needed. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: from table to form
    ... if you're talking about *sorting* records, don't do it at the table level. ... sort the records directly in the form, or sort them in a query and bind the ... query to the form. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: sortin a report by NULL valuse
    ... > the source of the report. ... Some of the records in the query have a NULL date ... whereas some other databases would sort them to the bottom. ... Prev by Date: ...
    (microsoft.public.access.reports)