QBE ? generic search utility?

[menc]

hi,
I need to create a generic search utility where users can search vertially every field in the table, and should be able to combine the different operands AND, OR in the search in order to get the required result.
Can this be done using QBE, or using something else? Please help me out. Thanks.

 

[Helene]

You can use QBE for some of this. Another thing you might be interested in looking at for this purpose, is the Developer Express Quantum grid. This does not alter the query, but allows you to do filtering, grouping and sorting within the grid on the client. It looks pretty much like the autofilter available in Excel.