sgmunson (7/24/2015)

Now...

Thanks for the assistance and suggestions, Steve & Scott. You guys here are very generous to say the least. I'm going to study the code you both posted.

GilaMonster (7/24/2015)

I need to count the machine only once, in the first month that it was serviced and ignore it from then on for that year. Any other services...

Thanks for the responses. The ultimate goal is an annual report that contains an accurate count on the number of machines that were serviced during the year, grouped by month....

How would I go about getting additional information from the subquery, like the ServiceDate for the record?

WOW! Thanks for the help! It works wonderfully! I didn't realize that you could place a subquery within an IN list. That is a neat little trick.

Sorry about not providing...