Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access 2010 query for null

Status
Not open for further replies.
dawnd3

dawnd3

Instructor
Jul 1, 2001
1,153
US
I used to know this but can't remember. When filtering out nulls, I still get nulls. So I change the criteria to

Is not null or not like ""

However, I still have many records with nothing in the field showing up. What is another variation of null or blank that I can check for? (and yes, I have removed all spaces.)

Thank you,

Dawn

 
Sort by date Sort by votes
I just solved my own issue. LOL The problem was with the OR instead of AND. Gets me every time! :)

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Query expression negative to a 0
Replies
6
Views
361
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
866
strongm
strongm
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
4K
dhookom
dhookom
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
248
OzFoxy
OzFoxy
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
716
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top