Not First/Last...Oldest/Newest

[gebobs]

Man...my Access foo has gotten rusty. Perhaps someone can help.

I want to get the oldest and newest inventory items used in a batch. So I made a totals query for which I enter the batch number and for that batch it returns the First and Last create_date. Of course, if the items are not entered into the table chronologically, it doesn't work.



e.g

...and there is other older inventory between these two in the table (e.g. 8/7/19).

I thought, oh easy, I'll just sort. Of course, there's nothing to sort. The query only returns the one record for the batch.

Sure I'm forgetting something fundamental. How can I get such a query to return the oldest and newest rather than first and last?

[CJ_London]

first and last are pretty meaningless without an order - so sorting on date_created should do the trick

but the usual way would be to use min and max

[gebobs]

first and last are pretty meaningless without an order - so sorting on date_created should do the trick

but the usual way would be to use min and max

Thank you for helping this old man across the road. Min/max...cripes how did I miss that?