|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
August 2nd, 2005, 11:20 AM
|
|||
|
|||
|
Nullable Fields
I am wondering if there is a way to (In a parameter query) search for nullable fields. I have records which use a "Nickname" for users however, not all user's still use a nickname. a handful do not have one. Thus I would like to do a search for nullable "Nicknames" but can't seem to figure it out. It is not a required field, should it be? I tried to do a search for "" and Is Null neither worked... I'm at a loss here... can anyone help me. Thanks!
|
|
#2
August 2nd, 2005, 01:49 PM
|
|||
|
|||
|
Try this for your criteria below the nickname field in your query:
[Select Nickname] Or (Is Null And [Select Nickname] Is Null) When you run the query and the parameter asks for the nickname, if the user presses Okay without entering any nickname, all names without a nickname will show up. Was this what you were looking for? lwells
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Nullable Fields |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
