User control of SQL

[Rik_StHelens]

I'm not actually doing this right now, but i have been wondering if it is possible for future use

Can you, through form controls allow users to select AND/OR and other SQL statements to create a dynamic query?

For example:

A list box allows a user to select AND/OR so the query could find records with:

INPUT1 AND INPUT2

or

INPUT1 OR INPUT2


I just wondered if/how this could be done, because i'm thinking of taking one of our databases down this route rather than having 50 different queries (and buttons) for all the possible searches a user could want to do on the one set of data....


Many Thanks

No urgency...i just wanted to ask...

 

[JANR]

Sure, here is one tutorial: http://www.fontstuff.com/access/acctut18.htm

JR

 

[Rik_StHelens]

Great!

Thanks very much..!