Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms > Stored Query - ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 44600 of 46529
Post > Topic >>

Stored Query - Criteria if box = true, => true, if box = false =>

by =?Utf-8?B?Qmx1ZVdvbHZlcmluZQ==?= <BlueWolverine@[EMAIL PROTECTED] Aug 4, 2008 at 09:47 AM

Hello,
MS Access 2003 on XP Pro.

I have a search panel i built and I want to all the user to either specify

"Search by other" or Don't.  The data gets pulled out of a stored query.

What I mean is that my data has a True/False field called "Other"  I want
a 
control the user can toggle between true and false to indicate "YES, limit

search to only those where Other = True" or "No, return all results 
regardless of Other."  I wouldn't necessarily mind being able to search
for 
the third state, "Yes limit my search to only those where Other = False"
but 
I don't necessarily need it.

Ideas?
-- 
BlueWolverine
MSE - Mech. Eng.
Go BLUE!
 




 2 Posts in Topic:
Stored Query - Criteria if box = true, => true, if box = false =
=?Utf-8?B?Qmx1ZVdvbHZlcml  2008-08-04 09:47:04 
RE: Stored Query - Criteria if box = true, => true, if box = fal
=?Utf-8?B?S2xhdHV1?= <  2008-08-04 13:13:10 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 17:28:41 CST 2008.