Display last column in which row contained data

[analyst1]

Hi there,

I have a table that looks like the following:
Name, Q1, Q2, Q3, Q4, Q5, Q6
ABC 3 , , , , , 2
CCC , , 4, ,5, 4

Sorry for the messing output, in essence, ABC has values for Q1 and Q6 only meanwhile CCC has values for Q2, Q3, Q4 only.

Now, Q2-Q5 are null values for ABC, and as such, I want a field that will display the last column in which the row did not have a null value. In other words, Last update field would read “Q6” for ABC, and “Q4” for CCC.

Is this possible in Access?



Any help is appreciated.

 

[analyst1]

any suggestions?

 

[Rabbie]

Firstly your data is not normalised. What will happen if you suddenly have a Q7.