adding together same values resulting from a query 1

[snipesnab]

I have created a query which outputs a coloumn in a new table of the software used on all pc's in our organization (from a table which has all the pc information).
It is one coloumn which displays all the software gathered from the query i created eg.:

pcanywhere
adobe
office 2000
adobe
office 2000
windows nt4
pcanywhere
office 2000

What i need to do is find out and get a value for how many times each software name appears so I can get a total value for the number of copies per software name we are using. How would i get a total value for each software name that appears in my new table eg:

office 2000 appears three times
pcanywhere appears twice etc etc..

 

[BillPower]

In your query's design view, select View from the menu, select Totals.

In the option Totals, select Count for your Software Field.

This should work ok.