Requirement: Need component that can help user to generate Query

I need to develop an app that helps users to query a database of customer information to produce lists which can be extracted. The selection criteria that will define the lists are properties values of the customers in the database and the queries being built can reference multiple properties combined using AND and OR. Individual clauses can use the usual range of SQL comparison operators such as equals, less than, greater than etc. The specific requirement is to present a query builder UI that enables non-technical end-users to create a query definition and which configures itself automatically based on the underlying database but has an object model which can be overriden to produce the exact options that I need. I'm sure that this problem has been solved before and would be grateful if anyone could provide an example of how to use an off-the-shelf component library that does this.


Solutions:

Submit a new solution to this problem >
CrossCompass Embedded Query Component
Overview: An ActiveX dll that is invoked by any COM compliant language e.g. VB6. So basically the system will load when you place the sample code behind a toolbar button in you system. The system has a separate admin suite for you to set-up database tables,views and stored procedures for user groups to access. There are various screens depending on how competent the user is.
(VB6\Windows)