sbbrown9924
Technical User
I am writing a query where I need to check to see if a field (TXflag) has a value in it. How would I write a query to determine if the field (a number field), is not null? Thanks.
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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A number field - how do you check to see if the field is not null 1
- Thread starter sbbrown9924
- Start date
- Status
-
1
- #2
belovedcej
Programmer
put
Not Is Null
in the criteria line of the field.
Not Is Null
in the criteria line of the field.
- Thread starter
- #3
sbbrown9924
Technical User
Thanks. Actually I posted this in the wrong forum - I should have put this in the JET SQL forum.
I'll repost there. thanks.
I'll repost there. thanks.
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
- Locked
- Question
- Locked
- Question