Good morning.
Is there an easy way to get a row number in a query?
I want it based on how I set up my query, with the sorts and criteria, and have a field in the query that gives it a row number starting with 1, regardless of what the auto number is in the table.
I have tried multiple things, but have not been able to figure it out.
Thank you for your help.