How many people joined each year?
You specify the criteria as normal for the column in the Query Design screen, or the WHERE / HAVING section of SQL. The table below shows some examples. Note that some of the details have calculated columns that make use of the date functions, Date, Year and Month. Access has many of these date manipulation functions. For an example showing calculated columns and the functions, see after the table.
