Count Number of occurances

[zekeftw]

Sorry in advance. Im sure this has been asked and answered already. I tried searching for an answer but I dont think i know the right terminology. I'm new to Access.



I have a table where 1 column has company names and the other has fax numbers

COMPANY 1	19998887777
COMPANY 2	16665554444
COMPANY 3	13332221111
COMPANY 1	18885552222
COMPANY 4	19996663333
COMPANY 1	19998887777
COMPANY 5	12225558888
COMPANY 1	19998887777
COMPANY 5	12225558888
COMPANY 1	18885552222

I'm need to run a query to count the occurances of COMPANY 1 for each fax number

19998887777	3
18885552222	2

I'm running Acess 2003 and had no luck using "Create query in Design View" or with the wizard.

Thanks

[June7]

Build an aggregate query with the query builder. Access Help has more info on using the query builder. This is really basic Access functionality.

SELECT [Fax], Count(Company) AS CountCompany FROM tablename GROUP BY [Fax];

Or build a report and use its Sorting & Grouping features with aggregate calcs in header/footer sections. This will allow display of detail records and summary data.

[zekeftw]

Thanks June7 that worked great.