B
Beagle1927
Hello,
I'm trying to create a query that pulls the top total amount paid
based on a combo box in a form such as 11%. where do I put the form
name and combo box in the SQL statement.
SELECT TOP 35 PERCENT Query1.[Cust ID], Sum(Query1.[Total Amount
Paid]) AS [SumOfTotal Amount Paid]
FROM Query1
GROUP BY Query1.[Cust ID]
ORDER BY Sum(Query1.[Total Amount Paid]) DESC;
I'm trying to create a query that pulls the top total amount paid
based on a combo box in a form such as 11%. where do I put the form
name and combo box in the SQL statement.
SELECT TOP 35 PERCENT Query1.[Cust ID], Sum(Query1.[Total Amount
Paid]) AS [SumOfTotal Amount Paid]
FROM Query1
GROUP BY Query1.[Cust ID]
ORDER BY Sum(Query1.[Total Amount Paid]) DESC;