If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how can i do a month search, by entering in a month through a par.
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 |
#2
|
|||
|
|||
What is a "month/date"?
Do you have a table structure that you could share with us? How about some sample records? -- Duane Hookom MS Access MVP -- "Heavenly Hash" Heavenly wrote in message ... 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 |
#3
|
|||
|
|||
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 ???? |
#4
|
|||
|
|||
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 ???? |
#5
|
|||
|
|||
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. -- Duane Hookom MS Access MVP -- "Heavenly Hash" Heavenly wrote in message ... 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 ???? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query Last Months Entries | FrankM | General Discussion | 9 | February 20th, 2005 02:13 AM |
Finding top 25 records per month | Robert Gillard | New Users | 0 | February 7th, 2005 11:06 PM |
date conversion | web_time | Worksheet Functions | 10 | December 25th, 2003 06:51 PM |
Retaining last months info when new month entered | Weatherall Ian D. | Worksheet Functions | 1 | October 27th, 2003 03:10 AM |
Getting a month from a date NOT using month() function! HELP! | Pedro Sendas Pereira | Worksheet Functions | 7 | October 23rd, 2003 02:03 AM |