access 2003, show active members for a given month...

[ltazz]

i have looked everywhere for the answer to this question,

ACCESS 2003


I need to find have a query output a list of memberID's that are current for a certian month, and by that i mean,

if a member1 startdate is 01-apr-07 and end date is 30-sep07,
and member2 startdate is 01-oct-07 and end date is 05-apr 07

if its may, and i want to know who is current in june i want # 1 to show up
and # 2 not to. i can get the current members quite easily with the now() command in a query, however this escapes me...
as a member may start june 1 and end june 4 but i still need to know they were in june.
please assist me in any way.
i will gladly give any other information on this topic if needed.
thank you.

[fperri]

Can you post the sql statment that you have built so far? You should be able to write your query using BETWEEN in your where clause for the date.

[ltazz]

I ended up figuring it out this morning...
rather than using the between clause, as i had 2 date ranges to work with.

i simply did a <= start and >= end on
that showed me all the dates starting before the last day of the month, and ending after the first day of the month...

which in turn showed me all dates that were active in that month...

thank you for your help.

[NeoPa]

That's good to get that. We've had a number of similar questions in here and very few members even 'get' the answer, let alone come up with it themselves. It's right of course :)