Criteria for Query

[sellis]

I am sure this is a quick question I am just not grasping. If there is a website to explain how to do this - feel free to just shovel me over there. I have a query where some of the records have a blank in a certain field (call it Union) and some have an entry there. Some of the entries I want, and some I do not. So, I need the blanks and some of the entries. I have tried running my criteria for, "" Not Like U*, to give me the blanks and exclude the two union entries that I do not want which both start with U, but Access (2007) did not like that. It only gave me the one entry that was neither blank nor a U which was an 813 in that field. Any suggestions?

 

[sellis]

Nevermind - just got it using Not Null Or Not Like U*. Figured that one out on my own after 30 minutes. Thanks ya'll