AnsweredAssumed Answered

Counting number of records with specific year in a date field

Question asked by MauriceG on Jun 21, 2015
Latest reply on Jun 26, 2015 by MauriceG

Title

Counting number of records with specific year in a date field

Post

Hi everyone,

I have a database that I use to manage my books. In one table, I have a Date field where I record the purchase date of the book. In a different layout, I have created 21 fields, one for each of 1995 to 2015 inclusive. How can I obtain in each of these fields the number of books (i.e. the number of records) in which the Date field contains the year in question. For instance, if I purchased 12 books in 2015, the field 2015 in my layout should show 12, and of course that number should update each time I record a new book with a purchase date in 2015. Same for the other years.

Thanks.

Outcomes