Access SQL Count number of items per month
Posted on 2010-11-08
I am new to SQL, and would like to know if there is an easy way to do the following:
I have a table called Builds, and the fields in it are BuildDate, Hull number, ShipType.
I want to make a chart that will plot the number of HullNumbers per month.
So for example, I want to select a range of Months, Say Jan 2010, to May 2010, and get a count of the number of HullNumbers plotted on a line chart . I guess it is like a count of the records per month.
If I have a Chart called chartB, what would the SQL query look like if it was the datasource?
I know this is a pretty simple thing, but I have not had more than a few days with SQL, and am really finding it a little esoteric.
Thanks for your help.