Limiting records reported in a query

[Lee Johnson]

Gang,
We have two tables in a query, Wells and Data, which are linked in the
query by a common field, Well_num. There are sometimes multiple records in
Data for a particular Well_num, each with differences in other fields such
as MD. I am wanting the query to report just a single record from table
Data which has the highest value of MD. How can I do that???

Thanks
Lee Johnson
(e-mail address removed)

 

[Guest]

Hi Lee

You could create a query with the fields MD and Well_num then add the additional row with 'group by', 'sum', etc. Don't know how this is called (Sum icon in icon bar) ;-
Nevertheless if you have added the row select 'max' for MD and 'group by' for Well_num save te query

Then create a new query with your two tables and the query above and that's it

Regards
Bern