Hello everyone! I am in need of some assistance.
The query was built for a report that shows units. These units have 3 states (a status) they can be in. Incoming, Active, or Paid. The report from this query shows the Active units but I recently added the Paid units to it. However, the query should only show the units that were changed to Paid during the month the report is ran. I have two date fields for when the unit was added and when the unit is paid.
So what I need to do is find a criteria for the paid date field that will show the paid units in the month that I am currently in and not any that are older than a month, but not override the other criterial in my status field. I don't want this to eliminate units that have the Active status.