All
Forum Tom's Guide : Article Discussions All
hi
I would like to ask you a question
I have the dates when the employees of company started working and the product that they sold during the month we want to find the name of the employee who had been working for the company more than ten years ago and has the highest number of product sold (ex.28,but the highest product sold is 30 but it doesnt meet th requirement which is the period of time more than ten year
I would really appreciate if i get an answer...thanks a lot
If you want help with a database query then we need to know the application package your using for a start.
I assume this is what you want help with?
ok sorry I forgot to mention ....
t Excel 2007...
<chuckle>
This is a school assignment right?
Reading the question thoroughly suggests:
1. All employees with less than 10 years of service are excluded from the simple dataset.
2. Of the remaining employees (those with 10 years or more service) sort (on sales) and select that employee with the highest sales record during the period.
I hope this helps.
yeah thanks a lot....
This topic has been closed by Reynod
Reply to REYNOD
There are 48 identified and unidentified users. To see the list of identified users, Click here.
2000-2009 Bestofmedia Group
Please mind
You are about to answer a thread that has been inactive for more than 6 months.
If you still wish to proceed, please ensure that your posting is original and does not duplicate or overlap any prior responses to this thread.