Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding The top Expense of an employee in a month
That did it! Thanks a lot, I really appreciate your correct and quick replies. -
Finding The top Expense of an employee in a month
Thanks a lot for your reply! I have just one more thing that I forgot to mention. I want to get the expenses made by employees in Descending order. I tried adding a clause like "order by Expense Desc" but it asked me to put the Expense field also in the Group by Clause. When I did that, then... -
Finding The top Expense of an employee in a month
Hi, I have a table that lists the expenses of all employees in the company in a month. So the table has three columns- number, employee ID, Expense I want to make a query that could list me the maximum expense made by all employees. In other words, my table has multiple expenses for each...
