Jump to content


Photo

Query help *solved*


  • Please log in to reply
2 replies to this topic

#1 hostfreak

hostfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 581 posts

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.

#2 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 13 September 2006 - 02:10 PM

Use != instead of == or if you want to check if the field is empty then just =''

#3 hostfreak

hostfreak
  • Members
  • PipPipPip
  • Advanced Member
  • 581 posts

Posted 13 September 2006 - 02:21 PM

Ah, got it. Thanks.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users