Query help *solved*
2 replies to this topic
Posted 13 September 2006 - 02:06 PM
I was wondering if there was any way to select fields that don't: == '' (have an equivalence of blank), from the query? I have a field that contains an edit date, but if it has never been edited it won't contain anything therefore it will be blank. I guess if there is no way, I could always make the ones without an edit date null and make that field null by default.
Posted 13 September 2006 - 02:10 PM
Use != instead of == or if you want to check if the field is empty then just =''
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users