Suggestions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top