Help In MS Access

[Rajesh Nair]

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!

 

[Debra Dalgleish]

You should post this question in one of the Access newsgroups, and
someone will probably be able to help you.
You could try microsoft.public.access.gettingstarted
or microsoft.public.access.forms

 

[Chris Leonard]

You'd find more help posting in an MS Access group.

Take a look at www.mrexcel.com - he also helps out with Access.

That said ...

What you need to do is alter your SQL statement to hold the month you want
to query, for example:

select * from table where month(Joining_Date) = my-chosen-month

(you didn't say what the data type was so I'm guessing it's type date)

HTH

Chris