When column can or cannot have data, how do I pull up blank only

C

Cindy B.

I have created an employee database with a column for professional degrees.
Some employees do not have degrees - so for them I left it blank. How do I
pull up a query that will show only those with blanks - what is the correct
argument for a blank cell.
Help - and thank you
Cindy B.
 
C

Cindy B.

When I put Is Null into that field - all of the cells were blank - it erased
all the fields - and I only want those employees with no degrees or those
cells which have nothing in them.
 
K

KARL DEWEY

Post your SQL by opening the query in design view, click on menu VIEW - SQL
View, highlight all, copy, and paste in a post.
 
S

Sam

In the criteria write the word Blank. You may have to write Is Blank. I
can't remember for sure.
 
C

Cindy B.

Gumby - thank you I went and tried different criteria - and IS NULL did
eventually work - thank you very much - will make for an easier sort. Not
sure what the initial problem was with the sort - but it works now. Maybe it
just needed to sleep on it. Thanks again - Cindy B
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to pull in data from rows and columns if there are blanks? 0
Some mail merge fields not pulling into document 2
Having Blank Cells, etc. ? 1
Query to show details of dataset when one type of data is still blank 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Lookup needs to fill two fields 2
query to show where no data in a stated column 0
Merging from an Excel file with graphics 1

Top