I have my data base almost finished, and I need to design two lookup queries that will retrieve specific record files.
First, our employees are evaluated twice monthly in various performance categories. These categories are ranked in decending order, according to each employee's performance in each category.
I need to design two queries to pull up the information I need:
The first query must be able to pull up the employee information, for a specific evaluation date. Every employee is evaluated each time. So, I need to be able to specify a specific date of evaluation, and have the system return the records for all employees evaluated on the single specified date.
Second, I also need to pull up records for one single employee. The query should return all of the records, in each category for one specific employee, for one specific, or multiple evaluation dates.
The basic records for each employee include the following basic information: Date of Evaluation, Employee ID Number, Employee First and Last name, Company information and company ID number.
The information for each employee, in each evaluation category, should also be returned.
I already have the forms and subforms to return ranking information, in each category. This information is returned, via a form listing all employees in ranking order, in each category. However, I have to scroll through every date to get to the latest evaluation information. Rather than having the ability to pull up ranking information for one single date.
I've also created a single form, for each category that will return just individual performance information for each individual employee. However, the form always begins with the first employee and I have to got through each employee, on e by one, to get to the single employee I need to review.
I would like to be able to enter in one date, and have the system return the records only for that one date.
I would also like to have the ability to enter in one employee ID or perhaps the three first letters of their name and have the system return the records for that one specific employee.
I know that I should be able to ad queries to my forms to achieve this. I just don't know how to design the queries.
Can someone please help me figure out how to do these two things?
Thank you for your help!
First, our employees are evaluated twice monthly in various performance categories. These categories are ranked in decending order, according to each employee's performance in each category.
I need to design two queries to pull up the information I need:
The first query must be able to pull up the employee information, for a specific evaluation date. Every employee is evaluated each time. So, I need to be able to specify a specific date of evaluation, and have the system return the records for all employees evaluated on the single specified date.
Second, I also need to pull up records for one single employee. The query should return all of the records, in each category for one specific employee, for one specific, or multiple evaluation dates.
The basic records for each employee include the following basic information: Date of Evaluation, Employee ID Number, Employee First and Last name, Company information and company ID number.
The information for each employee, in each evaluation category, should also be returned.
I already have the forms and subforms to return ranking information, in each category. This information is returned, via a form listing all employees in ranking order, in each category. However, I have to scroll through every date to get to the latest evaluation information. Rather than having the ability to pull up ranking information for one single date.
I've also created a single form, for each category that will return just individual performance information for each individual employee. However, the form always begins with the first employee and I have to got through each employee, on e by one, to get to the single employee I need to review.
I would like to be able to enter in one date, and have the system return the records only for that one date.
I would also like to have the ability to enter in one employee ID or perhaps the three first letters of their name and have the system return the records for that one specific employee.
I know that I should be able to ad queries to my forms to achieve this. I just don't know how to design the queries.
Can someone please help me figure out how to do these two things?
Thank you for your help!
