I have some ID strings in a table as below and what to know the index for 'Next'.
For example if 43094048 I want to return 3, 41911200 1 etc.
I can think of some cludgy ways to do this but I suspect there's a clever 'Access" method and wonder what it might be?
Thanks
First Next
42607288 41911200
42607288 35415599
42607288 43094048