how can i do a month search, by entering in a month through a par.

[Heavenly Hash]

I'm creatinh a database that stores the leave of the employees and i want to
create a month/date search, where the user can input a month/date and it will
bring up , all of the employees who are on leave for that month/date.....

Thank You in advance

 

[Duane Hookom]

What is a "month/date"?
Do you have a table structure that you could share with us? How about some
sample records?

 

[Heavenly Hash]

I have a table containing: Last Name, First Name, Position,Type of Leave and
the Start Date and End Date

The query consist of : Last Name, First Name, Position, Type of Leave and
Length of Leave

I want to create a query in such a way that a user can place in a date or a
month and it will bring up all of the person who will be on leave for that
particular date or month (i'm more leading towards the date)

How do i go about doing this ????

 

[Heavenly Hash]

I have a table containing: Last Name, First Name, Position,Type of Leave and
the Start Date and End Date

The query consist of : Last Name, First Name, Position, Type of Leave and
Length of Leave

I want to create a query in such a way that a user can place in a date or a
month and it will bring up all of the person who will be on leave for that
particular date or month (i'm more leading towards the date)

How do i go about doing this ????

 

[Duane Hookom]

This is kinda basic query stuff. I would recommend that you review
http://www.fontstuff.com/access/acctut08.htm on how to use controls on forms
to filter records in a query. Try create a form with text boxes for
Beginning and Ending dates.