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!

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

Rajesh Nair wrote:
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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

"Rajesh Nair" wrote in message
...
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!