Using criteria on 2 fields

[Nelmo]

I have a query with 2 date fields.
I want to display results that show records with the field [ChaseUpDate] that are blank (Is Null) but only the blank ones that have a date < or = to todays date in the field [PaymentDueDate](<=Now()).
If I put both the criteria on the same line I get nothing!!
If I put Is Null under [ChaseUpDate] and <=Now() under [PaymentDuedate] but one line down, I get records that are <=Now() but not blank in the [ChaseUpDate] field, and records that are blank in the [ChaseUpDate] field but have dates greater than Now().

Sorry it's a bit long-winded, but I'm at the point of chewing my keyboard

Any help Pleeeez

Nels

 

[Nelmo]

should have done a search on forum first
Found answer straight away

Compound Condition