I have a ploblem here. Need to find max values in 2 fields simultaneously, I have a table as follows:
Employee Account Months Data
Name1 Account1 January 0,42
Name1 Account2 January 0,5
Name1 Account3 February 1
Name2 Account2 March 1
Name2 Account2 April 1
Name2 Account2 January 0,3
Name3 Account4 April 0,7
Name3 Account5 April 0,3
I need to find the Max Month and Max data if I have January as max months for 2 times as inthe first case. I need this to get the correct Accaunt Name.
