M
Martin
How do I have null values show up on a query?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
That's a little vague. But you could do something like
Select * from tablename where fieldname is null;
If you add the table to a query in design view then specifically pull the field
you want to check for nulls into it, then under criteria type is null
(e-mail address removed)
Select * from tablename where fieldname is null;
If you add the table to a query in design view then specifically pull the field
you want to check for nulls into it, then under criteria type is null
(e-mail address removed)
V
Van T. Dinh
Perhaps you need to clarify / detail your requirement.
Do you want to select Record that has Null value in
certain Field or you want to display the Null value
(invisible) with something visible like the word "Null"?
Van T. Dinh
MVP (Access)
Do you want to select Record that has Null value in
certain Field or you want to display the Null value
(invisible) with something visible like the word "Null"?
Van T. Dinh
MVP (Access)
G
Guest
Yes exactly, I want to show blank records with the words
null.
null.
J
John Vinson
Yes exactly, I want to show blank records with the words
null.
To display the word NULL, you can use
NZ([fieldname], "NULL")
as the control source for a form or report textbox. This will not be
editable, however!
If you have a numeric field, set its Format property to
#;-#;"0";"NULL"
The four formats apply to positive, negative, zero and NULL values
respectively. This option *does* allow the field to be edited but
(AFAIK) applies only to numeric datatypes.