Sorry about the title, I wasn't actually sure how to word it and I'm sort of new doing queries in access. Here's a small example of the table I will be writing the query for, I basically want to just make a report table from it: Call it Tble z_Results
Location Analyte Results Qualifier 1 Aluminum 1 J 1 Aluminum 2 1 Aluminum 3 1 Barium 6 J 1 Barium 7 J 1 Barium 8 B 2 Aluminum 4 J 2 Aluminum 5 2 Aluminum 6 2 Barium 2 J 2 Barium 3 J 2 Barium 4
The Select Query I want will return the Analyte, Min of Result, Qualifier of the Min Result, Max Result, Qualifier of Max Result, Location of the Max Result
I'm having an problem associating the qualifier that is associated with the min result and max result. I haven't even tried getting the location of the Max yet, which I'm sure I will have a problem with.
I would like the end table to look like
Analyte Min Result Min Qualifier Max Result Max Qualifier Location of Max Aluminum 1 J 6 2 Barium 2 J 8 B 1
I've been looking online for answers such as writing join queries, self joins, but I don't have a good handle on SQL and can't get them to work. Just curious if this is possible and how it could be done.
Thanks in advance