Complicated Query needs some date range help

[KevinMCB]

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.

[KevinMCB]

Figured it out. In my field named [Status] I added onto the current line. It was:

Like "Active" Or "Paid"

I then added to it to make the following:

Like "Active" Or "Paid" And Year([Pdate])=Year(Now()) And Month([Pdate])=Month(Now())

This line still gives me the Active units, but only shows the paid units for the current month of the current year.