Counting Records

?

- -

Hi all
I have a table (called Contacts).
I would like to count (in a report, form, or using any other device
possible) the number of records, but insert some if statements in relation
to a field (called Contact Type).
ie I want to find out the total number of records where Contact Type =
Record Label, and display in the same form/report, count the number of
records where Contact Type = Radio.
Any suggestions?
Thanks
Matt
 
K

KARL DEWEY

SELECT YourDataTable.[Contact Type], Count(YourDataTable.[Contact Type]) AS
[CountOfContact Type]
FROM YourDataTable
GROUP BY YourDataTable.[Contact Type];
 
Top