I can't get this to work!
Train_No Station Passengers
8000 GER 100
8000 FRA 120
8000 ELA 80
9000 GER 25
9000 FRA 200
9000 ELA 50
All I want is to return the station and the passengers for each train where passenger is highest.
Therefore results are
8000>FRA>120 and 9000>FRA>200
Can this be done using simple Access queries. I tried grouping and using the max function on Passengers but it didn't work.
All help appreciated.
Train_No Station Passengers
8000 GER 100
8000 FRA 120
8000 ELA 80
9000 GER 25
9000 FRA 200
9000 ELA 50
All I want is to return the station and the passengers for each train where passenger is highest.
Therefore results are
8000>FRA>120 and 9000>FRA>200
Can this be done using simple Access queries. I tried grouping and using the max function on Passengers but it didn't work.
All help appreciated.