Access SQL help

I

Ikenest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top