Hi all.
I have 3 fields in a table
[ccan]= Client number
[amount]= in $$
[div]= Division
For each CCAN, I need to select the Division where the amount is the largest using Access 2003 visual interface.
I simply cannot achieve the desired results as either the data is not selected or the results are simply wrong.
I also tried sorting [amount] 'Ascending' and select the 'First of [Div] without success.
Can someone point me in the right direction?
SELECT [ccan],Max([amount]) AS Exposure,[Div]
FROM 0010_S_01
GROUP BY [0010_S_01].ccan, [0010_S_01].[Div Selection];
Thanks
If I did not say it before, I really appreciate the time and expertise of the users on this forum.
I have 3 fields in a table
[ccan]= Client number
[amount]= in $$
[div]= Division
For each CCAN, I need to select the Division where the amount is the largest using Access 2003 visual interface.
I simply cannot achieve the desired results as either the data is not selected or the results are simply wrong.
I also tried sorting [amount] 'Ascending' and select the 'First of [Div] without success.
Can someone point me in the right direction?
SELECT [ccan],Max([amount]) AS Exposure,[Div]
FROM 0010_S_01
GROUP BY [0010_S_01].ccan, [0010_S_01].[Div Selection];
Thanks
If I did not say it before, I really appreciate the time and expertise of the users on this forum.