Filtering in Access

  • Thread starter Thread starter Rajesh
  • Start date Start date
R

Rajesh

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. and reply to
(e-mail address removed)
many many thanks in advance

Regards

Raj
 
Hi,
1. Create a Query, that given month and year returns the
records that you want. read the documentation for the
built in functions Month(), Year() and Format (which you
might need to create the date format). remember you shold
border date values with "#" (i.e. MyDate > #1/8/2003#)
you can create it with variables like [MyMonth] in the
beginning, to see if it works all right. the query will
ask you to print in the month and year.
2. create a report based on the query, to present the
results.
3. create a form with the 2 combo boxes, set the query's
parameters to [Forms]![EnterMonthYearFrm]![Month/Year].
place a "Done" button on the form and attach it's OnClick
event to the OpenReport action.
HTH,
Ayelet
 
Back
Top