NZ function in query?

  • Thread starter Thread starter Ling
  • Start date Start date
L

Ling

How do i use the Nz function in a query.
In this query, it may contain null values but I need to
link this field to another table so those that has null
values are not shown. Any ideas?

Ling
 
Let me rephrase:

tbl1 tbl2

material3 RawPaperID
CoverSize RawPaperSize
RawPaperType
_______________________________
material3 linked to RawPaperID,
CoverSize linked to RawPaperSize
RawPaperType to be shown here
________________________________

Here, tbl1.material3 maybe null.
Thus, when i linked the 2 tables n try 2 show
RawPaperType, only records where material3 is not null is
shown.
But, I need to show all the records of material3 of tbl1,
regardless if it is null or not.

Any ideas?

Thanx

Ling
 
Back
Top