Access SQL help

[2007311009]

I would like to be able to create a view using SQL statement and pull data
(customer id, account id, customer name, amount due, region, loan type, days
past due, total acct receivable), by customer id where the total amount due
is greater than $500,000, (for each customer).

I am open to ways that make this work, either using SQL or using "create
query in design view".

Your help is much appreciated.

 

[bhicks11 via AccessMonster.com]

When you create a query in design view it generates the SQL. So if you click
view in the design screen, and select SQL you will see your SQL. Put the
fields you want in the query and the criteria (>500000) in the total due
column.

Bonnie
http://www.dataplus-svc.com