Getting the most recent value

[Anthony Viscomi]

Below is a snapshot of 2 fields within a table that I am trying to query:


PRIMUM PRIOBS
110966001 11847
110966001 9285
110966001 11758

I would like to create a query that outputs the largest PRIOBS for each
PRIMNUM and I am not quite sure how to go about this.

Any thoughts?
Thanks!
Anthony

 

[Ken Snell [MVP]]

SELECT PRIMUM, Max([PRIOBS]
FROM TableName
GROUP BY PRIMUM;

 

[Anthony Viscomi]

Thanks!

SELECT PRIMUM, Max([PRIOBS]
FROM TableName
GROUP BY PRIMUM;

--

Ken Snell
<MS ACCESS MVP>

Below is a snapshot of 2 fields within a table that I am trying to query:


PRIMUM PRIOBS
110966001 11847
110966001 9285
110966001 11758

I would like to create a query that outputs the largest PRIOBS for each
PRIMNUM and I am not quite sure how to go about this.

Any thoughts?
Thanks!
Anthony