troubleshooting Question

Access 2000 - Query question

Avatar of csehz
csehzFlag for Hungary asked on
Microsoft Access
7 Comments3 Solutions204 ViewsLast Modified:
Dear Experts,

I have a problem which seems easy but can not find the solution, basically have such table in the attached database

Item     Location      Labour hours
10101   West            10
10102   East              30
10102   West             20
10103   North            40

So having three columns, it contains the labour hours for items on certain locations.

Could you advise how a query could give that location which has the highest Labour? So the max of labour, but the with the belonging location. So based on the example this would be the result

10101   West            10
10102   East              30
10103   North            40

thanks,

Query.zip
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros