Need help for very complicated query inside a report

[snoopy]

Hello lovely Community,

I urgently need your help. I have one table and I would like to use a sum function for different columns.

My table
...
column 2012 = 23124
column 2013 = 1232134214
column 2014 = 123
...



At a result, function should be show column 2013, because that is maximum. Actually I have totally no idea how i could do this. Therefore I am really happy for any help,

[snoopy]

Ok, wrote my own VBA-Code, because query couldn't deal with those requirement

Public Function MaxOfColumn(ParamArray Values()) As Variant
Dim vItem As Variant
Dim vMax As Variant

vMax = Null
For Each vItem In Values()
If Not IsNull(vItem) Then
If vMax >= vItem Then
Else
vMax = vItem
End If
End If
Next vItem
MaxOf = vMax
End Function