how to chek if a field is not null

G

Guest

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.
 

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

Returning null values 4
Report-not required to print if field is null-concatenated field q 1
PARAMETER QUERY FOR IS NULL OR IS NOT NULL 5
counting Null fields 3
eliminating criteria in a query 4
Query criteria - exclude data and return all records if null 3
Long list of fields, how to check if either is null 3
NULL isn't always NULL 2

Top