Parameter query question 1

[Buzzmeister14]

I am running a report on an access 2000 database

there is a command button that promptts the user for a start date and then an end date and gives the clients due for renewal between those dates - the report is running fine

However, I now want to change the report so that it returns the clients for a particular month

and so ignores the year value in the table

for instance if I have two client

1 - renewal date=01/01/2005
2 - renewal date=06/01/2007

How can i return the clients with month = 01 and ignore the year

Any help greatly appreciated

 

[M8KWR]

where you have entered your parameter change it for the following:

Like "*/" & [startdate] & "/*"

You would not need a start date and end date just for them to enter the month number, but i would advise you to enter 01 if it January etc...

Hope this helps

 

[ZmrAbdulla]

I think you have to add an additional Date field to the query with the format dd/mm and enter the criteria to that particular filed.
HTH

Zameer Abdulla
Visit Me