Sign in with
Sign up | Sign in
Your question
Closed

All

Tags:
  • Article Discussions
  • Tom's Guide
Last response: in Tom's Guide
Share
February 3, 2011 5:30:29 PM

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

More about : question

February 15, 2011 12:31:26 PM

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?
February 15, 2011 4:48:08 PM

ok sorry I forgot to mention ....

t Excel 2007...
February 16, 2011 12:39:28 PM

<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.



February 23, 2011 6:34:52 PM


yeah thanks a lot....
May 15, 2011 10:26:28 AM

This topic has been closed by Reynod
!