MAX Value

[usafmeinweg]

I have a table that personnel enter data through a form.

Please Login or Register  to view this content.

What I am looking to do is create a query that will group the data so that it will show the [Personnel ID] with the most recent date for [Day Date] and so on.

Please Login or Register  to view this content.

Thanks in advance

[ConneXionLost]

Try:

Please Login or Register  to view this content.

Cheers,

[usafmeinweg]

Too easy. Thanks