First of all I am still a novice with Microsoft Access VBA and queries.
I am trying to work out how I can count records in a MS Access 2010 table, based on comparing a date field with today's date in an Event Procedure within a form.
Basically I have the field "app date" in a table called "tblMain"and I want to count the number of records in which the "app date" was more than 1 calendar month ago. I am assuming this uses a DCount statement but I'm not sure how to implement this.
Any help would be greatly appreciated.