By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,688 Members | 1,168 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,688 IT Pros & Developers. It's quick & easy.

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

P: 7
i have looked everywhere for the answer to this question,


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.
May 23 '07 #1
Share this Question
Share on Google+
3 Replies

P: 88
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.
May 24 '07 #2

P: 7
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.
May 24 '07 #3

Expert Mod 15k+
P: 31,770
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 :)
May 24 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.