Expression in a query to indicate last column that is not null

[MyaCCt]

Hi all! Me again!

Question; how would one write an expression in a query that will return the last used column from left to right? Hmmm.. maybe that didnt make sense. OK, so I have columns I through V with dates. If I, J, K, and L are populated, but starting with M - V is null, I want this column to indicate "L." (Being the last column with a valid entry.) Is this even a thing?

Thanks in advance for the help!
-MCC

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MyaCCt]

Got it, thanks!