what is wrong with this statement: SELECT TOP 3 ([Balance]) FROM [advertiser];

[armrodnun]

I am trying to do a query to find the three highest balances in an access table. The outcome is below. the 185 and 90 are not the highest numbers in the table. what am i doing wrong? the file is attached. Query1 Query1 Balance 185 90 0

Also, How to do a query to find the total balance and the amount paid for each person?

I Am new with Access please help me! I havve attached the file with my thread.

 

[RuralGuy]

Are you sorting Descending on the [Balance] field?