Dear friends

Please help me in following

I've an access data base , which has a table called employee
details. Following are the fileds in my data base
1.Emp_ID
2.Emp_Name
3.Joining_Date
4.Membership_Expiry_Date
I'm looking for the following,
To generate a report,
Example: There are five members in table.All the five are having
different membership expiry date.I need to get a report on base of
expiry month and year.
Means = Member # 1 Expiriy date is 09-Aug-2003
Member # 2 Expiriy date is 20-Aug-2003
Member # 3 Expiriy date is 11-Sep-2003
Member # 4 Expiriy date is 11-Sep-2003
Member # 5 Expiriy date is 09-Dec-2003
I should be able select the month and date from a combo box, which means
If I selet Aug-2003 then my report should show Member # 1 & Member # 2
only, if I select Dec-2003 then the report should show only Member # 5
only. Moreover is there any way to set up a popup message to show the
members list whose membership expiring the current month.

Please give an idea to do the above.
many many thanks in advance

Regards

Raj

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!