Hi Everyone,
I have a report that prompts for the month in which records are needed that counts the number of Issue Types logged. The report then populates those results at the top with the Issue Type and the total count for that month.
At the bottom, is a YTD table that counts all records logged up to that point. This report is run on the 5th of each month. How can I modify the YTD query to only include up to the last day of the previous month? Obviously I would still need a running total all year just not including the current mnth's record count up to that point.
The field nanes I have are:
-ID (PK)
-IssueType
-VisitDate
Thanks for any assistance. I can provide more info if needed.