leave fields that are NULL out of query

[Ankie]

Hi,

I have 2 tables... one with 'answers' (on questions) and one with these 'questions'.
Now I want to show the questions with their answers on a rapport
(based on a query) .. but only these whereby the answer-field is NOT NULL..

So I have already:
ansques1: IIf([answers.1] Is Null;Null;[questions.1]+" "+[questions.1])

But now if the answer-field is NULL, then the ansques-field is also NULL...
I want if the answer-field is NULL, to have no new field.. like ansques1.. just want to leave it out of the query... can someone help me with this?

Thanks in advance,

Ankie

 

[KeithG]

Use Not Null in the criteria row

 

[neileg]

Should be Is Not Null