Query that shows records equalling different values

[greenfalcon]

This is a very quick question. I have a query what i need it to do is show me all values that equal 2 and any records that are blank, this is what the criteria looks like currently

Field: Month([FDate])

Total:Group By

Criteria: Month([DDay1])

Now the way this works is it only shows records where the field meets the criteria, in this case Month([FDate]) = 2

I need the criteria to say if Month([DDay1])=Month([FDate]) Or is equal to "" Then display records.

EDIT: I just found out how to view blank values but what if records for it dont even exist... i still want to show the other fields..

Thanks
Jason

 

[ListO]

If I'm understanding you correctly, you simply need to add an 'or' criteria entry.
In design view of your query, add another entry in the box below the criteria box (it says 'or' over there on the left). It should say 'Is Null"
After that your query will bring up any null entries, and any entries which meet your original criteria.

Good luck.


-Curt