I've got a query that is filtering down to year to date entries and then I'm using a DCount function in a report to show that number. I'd also like it to show the current month-to-date number as well. Outside of creating a whole query, is it possible for the DCount function to be coded in a way that just generates the MTD number based on the YTD query?
My current DCount function is simple and my date field is submissiondate:
Code:=DCount("*","qryYTD")