Pulling records with from last month w/ start end dates

[BigFishCA]

Hello, I'm trying to make a query criteria that returns a record of a class taking place during the span of last month that fall between a start and end date that do not contain last month's information. For example I have a class that started in February and will end in July. This class took place within last month (may). I can pull the record that begin within last month (dates containing may) and end within last month.

[ranman256]

make a form with 2 text boxes, txtStart, txtEnd
then the query will use them,

select * from table where date between forms!myForm!txtStart and forms!myForm!txtEnd

[alansidman]

What fields are in your table. Which field(s) are you attempting to query. Your explanation is unclear. Try again to explain it more clearly.

[BigFishCA]

I have a class name, class start date, class end date, how many students are in the class. My issue lies in returning the classes that were taught last month (may) where the start dates and end dates do not contain specific mention of may. For example I have a class that begins in February and ends in June. No mention of May in those dates, yet the class was in session during may. I want to include that clad in my results. I currently can return class records that have start dates such as may 2 and those that end in May. I thought about averaging the dates and finding a midpoint, however, this isn't always accurate. Although the midpoint may sometimes result in a date within the month of May there may be times were it may not. My thought process is extracting the month values of the start date and end date, then, depending on when I run the query the value of last month is calculated and used to check if it falls between the start and end date. Hope that explains it better.

[BigFishCA]

This query is used to populate a report to summarize the classes and students taught during the month of May. The month of May is subjective to when I run the report. Next month it'll return values for June and so forth. I'm currently using the criteria of " Year([START])* 12 + DatePart("m", [START]) = Year(Date())* 12 + DatePart("m", Date()) - 1" to select the records with start dates that contain dates for last month. The same for end dates.

[Micron]

Why May? What about March or April?
This may be as simple as getting the classes with Null as the end date (if there isn't one, it's still running). Unless you have hours/attendance/room data/something that relates to that class that was recorded for May, I see no way of retrieving records for just May. If that's what you want, and you have no such data for May, then you probably have a design problem. I just don't see how your posted expression could help since the dates you're trying to use don't have any relationship to May (or any other month that happens to fall between them), plus as you've indicated, there's no end date anyway for a class that's still being conducted.