Getting the most recent value

  • Thread starter Thread starter Anthony Viscomi
  • Start date Start date
A

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
 
Thanks!
Ken Snell said:
SELECT PRIMUM, Max([PRIOBS]
FROM TableName
GROUP BY PRIMUM;

--

Ken Snell
<MS ACCESS MVP>

Anthony Viscomi said:
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
Click to expand...
Click to expand...
 
Back
Top