|
| 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
February 21st, 2005, 03:37 PM
|
|||
|
|||
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
February 21st, 2005, 05:31 PM
|
|||
|
|||
|
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
February 23rd, 2005, 01:29 PM
|
|||
|
|||
|
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
February 23rd, 2005, 01:29 PM
|
|||
|
|||
|
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
February 23rd, 2005, 03:07 PM
|
|||
|
|||
|
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 |
Linear Mode
