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
|
|||
|
|||
Query/Report based on Employee Hire Date
This is probably a very basic thing that I just don't know how to do.
I need to pull a report on people hired in December, regardless of year, for performance appraisals. The hire date that I currently have in the database is in the mm/dd/yyyy format. How do I sort on just the Month portion of this. I can then build my reports off of the query. Thank you in advance for any help or suggestions. Steve |
#2
|
|||
|
|||
Query/Report based on Employee Hire Date
Add a calculated field to the query.
Field: Month([Hire Date]) Criteria: 12 That gets everyone ever hired in the month of December. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Steve wrote: This is probably a very basic thing that I just don't know how to do. I need to pull a report on people hired in December, regardless of year, for performance appraisals. The hire date that I currently have in the database is in the mm/dd/yyyy format. How do I sort on just the Month portion of this. I can then build my reports off of the query. Thank you in advance for any help or suggestions. Steve |
#3
|
|||
|
|||
Query/Report based on Employee Hire Date
That is perfect! Thanks so much John!
I'm posting another question in a second, about a macro not working if you could take a look at that one too it would be wonderful! On Dec 8, 3:15*pm, John Spencer wrote: Add a calculated field to the query. Field: Month([Hire Date]) Criteria: 12 That gets everyone ever hired in the month of December. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Steve wrote: This is probably a very basic thing that I just don't know how to do. I need to pull a report on people hired in December, regardless of year, for performance appraisals. The hire date that I currently have in the database is in the mm/dd/yyyy format. How do I sort on just the Month portion of this. I can then build my reports off of the query. Thank you in advance for any help or suggestions. Steve- Hide quoted text - - Show quoted text - |
#4
|
|||
|
|||
Query/Report based on Employee Hire Date
Also in Criteria you can put [Enter Month] as a parameter, when you run the
querry it will ask you for the month ie Jan "Steve" wrote: That is perfect! Thanks so much John! I'm posting another question in a second, about a macro not working if you could take a look at that one too it would be wonderful! On Dec 8, 3:15 pm, John Spencer wrote: Add a calculated field to the query. Field: Month([Hire Date]) Criteria: 12 That gets everyone ever hired in the month of December. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Steve wrote: This is probably a very basic thing that I just don't know how to do. I need to pull a report on people hired in December, regardless of year, for performance appraisals. The hire date that I currently have in the database is in the mm/dd/yyyy format. How do I sort on just the Month portion of this. I can then build my reports off of the query. Thank you in advance for any help or suggestions. Steve- Hide quoted text - - Show quoted text - . |
Thread Tools | |
Display Modes | |
|
|