Query to return blank or null items.

**mulefeathers** · 10-24-2013, 11:57 AM

I have a query that is made up of two tables. They are joined use the field "Part Number". I have 5 columns Sales Order, Part Number, Work Center, Date, Delivery. I have it setup with a criteria on the date field using < Date()+10 This works but it only returns values where there is data in every field. I know there are rows that have data in every column except work center but those are omitted. I have tried IsNull Is Null ="" like "" and a few others that didn't work either. All I am trying to do is return the rows of data where work center is blank. Thanks in advanced.

**RuralGuy** · 10-24-2013, 12:04 PM

In the design view of the query, right click the line between the tables and see what type of join you have.

**mulefeathers** · 10-24-2013, 12:22 PM

That got it. Thanks

**RuralGuy** · 10-24-2013, 12:45 PM

Great! Glad we could help.

Query to return blank or null items.

Thread Tools

Query to return blank or null items.

Similar Threads

Union Query to return Null

Return blank results in query when field is fed by a look-up relationship

Count query return zero instead of null/blank

I only want it to return items with a NULL value in my field called "ReportReceived".

Query return 0 for null values

Posting Permissions