query question

C

cherrynich

I am doing a select query by form and I need an expression for the query
design that will let the user either enter a value or leave it blank. if the
user leaves the box blank it will return all values, if they enter a value it
returns only that value. could someone help me with an expression that will
work?
thanks
nick
 
B

Brendan Reynolds

SELECT * FROM TableName WHERE FieldName = [Whatever] OR [Whatever] IS NULL

.... where 'Whatever' is the prompt you want the user to see, if you're using
the built-in query parameter dialog, or a reference to a form control if
you're using a custom form .

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Top