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!

[pod]

if you use MS Access as the platform for manipulating data, the same logic you used with JAVA can be used with VBA (VB script for Access)
... of course you will have to learn the syntax differences

if you've never worked with MS Access Forms, I suggest, downloading a simple project and studying it (Google Northwind database)

[Rabbit]

I suspect you can do everything with SQL.