I am trying to do a query to find the three highest balances in a access table? This is what i have on my SQL but it gives me this error: "Character found after end of sql statement"
SELECT Table1.[Advertiser Number], Table1.Name, Table1.Balance, Table1.[Amount Paid]
FROM Table1; SELECT TOP 3 MAX([Balance]) As Balance FROM [Table1];
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.
SELECT Table1.[Advertiser Number], Table1.Name, Table1.Balance, Table1.[Amount Paid]
FROM Table1; SELECT TOP 3 MAX([Balance]) As Balance FROM [Table1];
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.