Replies

Wow. That’s amazing. I’m still trying to get my head around all those queries!
How does this criteria work in the qryYearEnd query? DateSerial(Year(Date())+(Month(Date())<4),3,1) I think I’ve figured out the rest of them.
This will work like a charm. Thanks so much. You’re the best.

Hans, I’m attaching the table that’s causing me the problem.

As for variance, they want to know the actual difference between the current month’s numbers and compared month’s numbers and the percentage this represents. If we had 10 employees last month and 15 this month, that would represent an absolute variance of 5 and a percentage increase of 50%. They want this for each section: Current versus last month; Current month versus last year-end and Current versus last year.

Any help would be greatly appreciated!