How to return full line of query in MS Access 2016

[jtmott]

Hello,
I am querying a table that has multiple entries. I need to find a way to return the entire line of each record.
Below is a sample of the table. I need to return the entire record based on "ODPRD" and the lowest "OOPNO".


Example:

ODPRD	OORD	OOPNO	OOPDS	OWRKC	OQTY	OQTYP	% Comp
10043	215402	20	SCR MCH TO PRINT-10043	2600	2000	0	0
10043	215402	25	DEBURR HOLE	2700	2000	0	0
10043	215402	30	STAGE TO WAREHOUSE	8400	2000	0	0
10051	213277	20	DRILL 5/8" HOLE TO 10051	2700	500	0	0
10051	213277	30	DEBURR HOLE	2700	500	0	0
10051	213277	40	STAGE TO WAREHOUSE	8400	500	0	0

Results needed:

ODPRD	OORD	OOPNO	OOPDS	OWRKC	OQTY	OQTYP	% Comp
10043	215402	20	SCR MCH TO PRINT-10043	2600	2000	0	0
10051	213277	20	DRILL 5/8" HOLE TO 10051	2700	500	0	0

Thank you for any help!

[NTC]

create a select query using query design view including just 3 fields:

ODPRD

OORD

OOPNO

then option it to be an Aggregate query (up in ribbon is sigma symbol like large E)
leave the first 2 fields in their default 'Group On' but change OOPNO to MIN

Save this query with a name: A1

Then make a new query - adding your table and also A1. Draw join lines between the 3 fields. Add all the fields of the table into the query.

This will give the results you seek.

[jtmott]

That worked great Thanks for the help!