|
 |
access thread: LIST BOX as Multi Select Criteria
Message #1 by George Oro <georgeoro@y...> on Tue, 19 Mar 2002 21:29:03 -0800 (PST)
|
|
Hi Guys,
I have a List Box (Multi Select=Simple) as my Criteria
in my Report Criteria Form
List Box Value:
-Member
-Ex Member
-Others
-Prospective Member
How can I set my Query:
1)If I select Member only in my List Box then only
Members will list OR?
2)If I select more than one Member and Prospective
Member (not in sequence A-Z) then only Member and
Prospective Member will list?
Basically, I want to have a flexible or a multi select
criteria to generate my report. Are the above criteria
possible? Please help me guys?
Thanks in advance,
George
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
Message #2 by brian.skelton@b... on Wed, 20 Mar 2002 07:02:39
|
|
George
One of these articles on the ever useful Access Web should set you on your
way:
http://www.mvps.org/access/forms/frm0007.htm
http://www.mvps.org/access/reports/rpt0005.htm
Brian
> Hi Guys,
I have a List Box (Multi Select=Simple) as my Criteria
in my Report Criteria Form
List Box Value:
-Member
-Ex Member
-Others
-Prospective Member
How can I set my Query:
1)If I select Member only in my List Box then only
Members will list OR?
2)If I select more than one Member and Prospective
Member (not in sequence A-Z) then only Member and
Prospective Member will list?
Basically, I want to have a flexible or a multi select
criteria to generate my report. Are the above criteria
possible? Please help me guys?
Thanks in advance,
George
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
Message #3 by ProDev <prodevmg@y...> on Wed, 20 Mar 2002 06:34:19 -0800 (PST)
|
|
--0-555319068-1016634859=:80221
Content-Type: text/plain; charset=us-ascii
I have a sample mdb (A97) that shows how to create a report and dynamically select your fields. I didn't create it, however I have
used the underlying concepts for other applications I have built. You may have it if you wish. Just send an email to
ljprodev@y... and state which sample you want.
George Oro <georgeoro@y...> wrote: Hi Guys,
I have a List Box (Multi Select=Simple) as my Criteria
in my Report Criteria Form
List Box Value:
-Member
-Ex Member
-Others
-Prospective Member
How can I set my Query:
1)If I select Member only in my List Box then only
Members will list OR?
2)If I select more than one Member and Prospective
Member (not in sequence A-Z) then only Member and
Prospective Member will list?
Basically, I want to have a flexible or a multi select
criteria to generate my report. Are the above criteria
possible? Please help me guys?
Thanks in advance,
George
__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/
Lonnie Johnson, ProDev, Builders of MS Access Databases
Let us build your next MS Access database application.
http://www.galaxymall.com/software/PRODEV
Send and Receive payments for free with PayPal: http://www.paypal.com/refer/pal=Y6TYF7YF8E2JG
---------------------------------
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
|
|
|
View Cart
