Forum Discussion
Adding sub form for a new year
I really appreciate all of your help. I am going to put all the individual years into one file which I can do. However, I have a problem. There is an "Autonumber" field that when I put two years together I get a continuous running number. I want to count the number of payments received by year. I have a field "Year Dues Paid" that I can use to count payments. The date changes from year to year, i.e. 2024, 2025, etc. How can I start the count over each year.
You generally don’t want to store that count in your table. That’s something you calculate on the fly. For example, you can use DCount in a query, form, or report to count the number of payments for a given year, or just use the aggregate Count function in a totals query. There are lots of different ways to do it, but storing calculated values like this in the table is not considered good database practice. See this video for more.
