I am running a query (of a query) where 4 values fit the criteria. I know that I can use FIRST and LAST to find 2 of the values. How can I find the other values, and work with them. My report prints the First([Field]), but do I 'find' the second value? I know in other places I could do First(NotFirst([Field])), but that does not seem to be a choice in ACCESS.
I'm sure that I'm not the first to ask this question, but I did not see where.