IS NULL is not working on query

[ariel20029]

Hi, Can you please help . I have never had this happen before but the is Null is not working. Here is the SQL;

SELECT [Q3 Add Dates and SRR].[Arrangement ID], [Q3 Add Dates and SRR].[Q1- ADR INFO].[Order Number], [Q3 Add Dates and SRR].ADR.[Deal Number], [Q3 Add Dates and SRR].[Sales Document Type], [Q3 Add Dates and SRR].[Net License Fee Amount]
FROM [Q3 Add Dates and SRR]
WHERE ((([Q3 Add Dates and SRR].ADR.[Deal Number]) Is Null) AND (([Q3 Add Dates and SRR].[Net License Fee Amount])<>0));

[Seth Schrock]

Define "not working". Do you get an error message or are the results not what you were expecting?

Also, please verify that you are using Access. The field reference looks kind of like SQL server, but it could be a typo or just something I've never seen before. But you might check your field reference [Q3 Add Dates and SRR].ADR.[Deal Number].

[NeoPa]

On your line #3 you have a dodgy reference to :

([Q3 Add Dates and SRR].ADR.[Deal Number])

This is what you're testing with Is Null. The latter is fine, of course. Your reference is where the problem lies.

NB. Please try to follow the guidelines in future about asking questions sensibly. It's hard to give answers when the question barely makes sense.