Suggestions

G

GRIFFO

Any suggestions on query / interface design for a multiple variable where
clause query.

That is
SELECT * FROM CUSTOMER WHERE SERVICE_PROVIDED = "a number of variables could
go in here".

Now I am aware of a many to many relationship here but have tried to
simplify the question. I have multiple types of SERVICE_PROVIDED and want the
user to be able to type (preferrably select) one or more and the query to
run. The SERVICE_PROVIDED is not static therefore check boxes or similar I
suppose wont do.

An example query for explanatory purposes is (ingoring syntax errors) :
SELECT * FROM CUSTOMER WHERE SERVICE_PROVIDED = "Disability" OR
SERVICE_PROVIDED = "Aged" OR SERVICE_PROVIDED = "Youth training"

I would assume something like a multiple selection list or combo box that
populates with a query from the source table, and then somehow uses a loop to
populate the where clause of the query. I have never done somehting like this
before but always required it. I am sure you smart people have done this
many times before and would appreciate your advice. Any suggestions would be
appreciated.

Thanks in advance.
 
G

GRIFFO

Thanks Dan. Your assistance has also led me to a very good website. It
explains this process, (Multi-select list boxes for truly excellent run-time
query and report design). This site has code, code comments and full
explanations all the way through. This is not an ad! It is just the best
semi-advanced access query and form design website (and many other things)
that I have seen in the last few years. I can finally do what I want in
access without having to learn VBA fully. The little knowledge and related
explanations here is a wonderful resource. Finally I can make one report and
have a form change that one report to include whatever, and however I want it.

For other wanting information on multichoice, 'interactive' queries at
run-time, Visit the site at http://www.fontstuff.com/access/index.htm A bloke
by the name of Martin Green does it and his instruction and simple language
is outstanding.
Needless to say, I can highly recommend it.
 
Top