I have 2 tables, the first table (tblCarTypes) has 2 columns, CarTypeID and CarType. The 2nd table (tblCarRecords) has some records, where one of the columns is the CarType (which is populated with the CarTypeID). I want to create a query that will output a count of records from carRecords for each CarType. Samples of the data for each table is below.
The output I would like based on the sample data below would be like this below example. Could someone assist?
This is what I want the query to output:
CarType | Count
suv | 3
pickup | 3
compact | 1
tblCarTypes:
CarType | CarTypeID
suv | 1
pickup | 2
compact | 3
tblCarRecords:
Date | CarType | ID
3/2/15 | 1 | 1
3/3/15 | 1 | 2
3/4/15 | 1 | 3
3/4/15 | 2 | 4
3/4/15 | 2 | 5
3/4/15 | 2 | 6
3/4/15 | 3 | 7