|
| 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
February 15th, 2007, 01:58 AM
posted to microsoft.public.access.queries
|
|||
|
|||
how to chek if a field is not null
I have query that populates a Report based on values and fields from two
tables. However, it shoud not include any record where one specific field is blank. in the query design view, under that field in "criteria", I need to specify some thing like "where is not equal to NUll" how can I do this? The field in question is of memo type. 
|
|
#2
February 15th, 2007, 02:06 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
how to chek if a field is not null
Moe, how about Is Not Null
-- Paul B Always backup your data before trying something new "Moe" wrote in message ... I have query that populates a Report based on values and fields from two tables. However, it shoud not include any record where one specific field is blank. in the query design view, under that field in "criteria", I need to specify some thing like "where is not equal to NUll" how can I do this? The field in question is of memo type.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
