Nulls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a "Location" field. The majority of the records in the
table have nothing in this field.

I have a query based on this table which includes the Location field. I
would like the query to display records where the Location field contains
nothing.

In the query I have tried IsNull and ="" in the query design for Location,
but I can't seem to get the query to work properly. When I view the query,
there are no records.

Any assistance is appreciated.
 
Shael said:
I have a table with a "Location" field. The majority of the records
in the table have nothing in this field.

I have a query based on this table which includes the Location field.
I would like the query to display records where the Location field
contains nothing.

In the query I have tried IsNull and ="" in the query design for
Location, but I can't seem to get the query to work properly. When I
view the query, there are no records.

Any assistance is appreciated.
Click to expand...

Is Null (two words)

IsNull() is a VBA function, not a SQL one.


SELECT *
FROM YourTable
WHERE Location Is Null
 
Back
Top