I am now trying to count the number of months an agent was active (from contract date field) in the previous year.....as well as the current year.
These dates are stored as dates - so no formatting or conversions need to be done, I just want to know how to write an expression in design view that will tell me how many months an agent was active last year, whether his contract date was from last year, the year before, or this year (which would return a zero, hopefully).
And the same for the current year.
Any help? I don't even know where to start (been hunting online and in my access book) so I have no SQL to post on here.