Search Field

[amerifax]

I have hundreds of searches to do to day. I'm using Access 10. Every search takes to long. I select the top of field column and A to Z & Text Filter contains. It takes to long. Is there a faster way.

Bob

[rpeare]

Have you thought about writing a query instead of just sorting a table (which sounds like what you're doing). Also, it really depends on how large your dataset is as to how long a query will take to run against that dataset.