|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 22nd, 2006, 08:48 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
When column can or cannot have data, how do I pull up blank only
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. 
|
|
#2
August 22nd, 2006, 08:57 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
When column can or cannot have data, how do I pull up blank only
Critera would is Is Null in the that field.
Cindy B. wrote: 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.
|
|
#3
August 22nd, 2006, 09:11 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
When column can or cannot have data, how do I pull up blank on
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. "gumby" wrote: Critera would is Is Null in the that field. Cindy B. wrote: 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.
|
|
#4
August 22nd, 2006, 10:14 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
When column can or cannot have data, how do I pull up blank on
Post your SQL by opening the query in design view, click on menu VIEW - SQL
View, highlight all, copy, and paste in a post. "Cindy B." wrote: 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. "gumby" wrote: Critera would is Is Null in the that field. Cindy B. wrote: 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.
|
|
#5
August 22nd, 2006, 10:29 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
When column can or cannot have data, how do I pull up blank on
In the criteria write the word Blank. You may have to write Is Blank. I
can't remember for sure. "KARL DEWEY" wrote: Post your SQL by opening the query in design view, click on menu VIEW - SQL View, highlight all, copy, and paste in a post. "Cindy B." wrote: 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. "gumby" wrote: Critera would is Is Null in the that field. Cindy B. wrote: 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.
|
|
#6
August 23rd, 2006, 01:49 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
When column can or cannot have data, how do I pull up blank on
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 "gumby" wrote: Critera would is Is Null in the that field. Cindy B. wrote: 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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
