Max Function

Join Bytes! wrote:

Try:

SELECT SampleID, SiteID, Chemical, Results, Units, Comments FROM
tblSamples WHERE Results = (SELECT MAX(A.Results) FROM tblSamples AS A
WHERE A.Chemical = tblSamples.Chemical);

Note that ties for Max(Results) for a given Chemical will all show.

James A. Fortune
Join Bytes!

Worked like a charm, thank you very much!

James

Join Bytes! wrote:

I'm glad it gave you the results you wanted.

Based on information from one of Salad's recent posts somewhere, also
try using the DMax function to see if it affects the query's speed:

SELECT SampleID, SiteID, Chemical, Results, Units, Comments FROM
tblSamples WHERE Results = DMax("Results", "tblSamples", "Chemical = "
& Chr(34) & tblSamples.Chemical & Chr(34));

James A. Fortune
Join Bytes!

In reality the texts of the Rosetta Stone were of limited use because
the hieroglyphs were so damaged, as Champollion had pointed out in his
'Lettre à M. Dacier': 'The hieroglyphic text of the Rosetta
inscription, which should have lent itself so happily to this research,
because of its breaks only presented the single name of Ptolemy.'
Having become the focus of attention for would-be decipherers, the
Rosetta Stone still remains a powerful popular symbol, even though its
inscriptions failed to fulfil the hopes and expectations they aroused.
Other inscriptions and papyri were far more important in providing
clues to decipherment. -- The Keys of Egypt, Lesley and Roy Adkins,
ISBN 0-06-095349-7