Help with a Count...

[kgbo]

Hello,


I have created a table that is pulling information when entered into a form.
What I would like to do is to summarize the information into maybe a pivot table or a query..not sure what is best at this point.
Let me explain my table:
I have list items that range from P1 to P10 in two seperate columns. How would I do a count so that these two columns get combined together.
Such as: (Keep in mind, these columns would be laid out next to each other, not bellow)
Column 1:
P1
P2

Column 2:
P2
P3

I would like the table to take the above information and summarize it as follows:
Category:
P1
P2
P3
Number Count:
1
2
1

[Neologic29]

Is the data in those two fields a string or a number? I think doing a query and creating a calculated field which either counts or sums (depending on the type) the data in the columns would probably work.

[Perceptus]

Just an idea to get you started. Haven't tested.


select Distinct(Column1) As Category, Count(Distinct(Column1)) as Number from tableyoudidntspecify
union all
select distinct(column2) as category, count(distinct(column2)) as number from tableyoudidntspecify