Query by Form is a great tool, because the user can define almost any query they want. On the other hand, designing a specific query can save the user time when that query is complicated. Here is a way that you can have the best of both worlds: Combine QBF with Scripting Bill Warner Full Story