What is the best way to do a database search?

[rich s smith]

I'm proposing an idea for the company that I'm interning with. They use Access and I have used it before. I was trying to decide what the best method would be to search the database for certain customers to find data that meets certain requirements (a customer that has had two or more transactions with us, all being under $2,500 but totaling over $3,500). I have mainly worked with Java and SQL and know how I would search for these requirements using Java (for loops to compare the customer number, if/and statements to compare the details), but what is the easiest way to develop a list with multiple restrictors in Access? I know I could make multiple tables and keep narrowing down data from there, but that seems like it would take up too much time/memory. Also, this process would need to be automated.

Thanks!

[munkee]

Create a query within access to do this all for you. It basically executes a SQL string but access has a pretty useful user interface to allow you to easy add and remove criteria without having to directly edit SQL strings