Hi, how are you? hope you are doing well..

it has been weeks for me trying to get the expression that guide me to what I need
let's say:
I have a table contains column( Name, Age, Nationality)
and I've made a query that shows only people their ages are 20
what I need is to have row numbering (ID), so whenever I add another person's data who's age is 20 it will be be shown in the query with it's specific ID number (increase by one each time)
How can I do it, I will be glad if you answer me quickly!
Regards

---

Reply from Alex Hedley:

You can either have an AutoNumber Field but I don't think this is what you are after.

You could use DMAX to increment your own Counter.

You could use the Row Number example tip.