Easy code problem

Results 1 to 3 of 3

Thread: Easy code problem

  1. #1
    Join Date
    Dec 1969

    Default Easy code problem

    This will sound dumb but I&#039ve never had to do it before. How in the heck do you write the code for where a field is empty? As an example I want to select a record where field1 is empty. I&#039ve always done = to &#062; or &#060; but never null or empty.<BR><BR>God I feel like an idiot. I&#039ve tried several way to no avail. Can someone help me out here?

  2. #2
    Tony Guest

    Default RE: Easy code problem

    Have you tried something similar to _field1 = ""_ ... I used to have the same problem, but it&#039s not really NULL, it&#039s a blank space. Hope that helps!

  3. #3
    MG Guest

    Default RE: Easy code problem

    Use isnull(variable) or <BR>variable = "" <BR>Here is a handy function<BR><BR>function checknull(val)<BR> If isnull(val) or val="" then<BR> checknull = "&nbsp;"<BR> else<BR> checknull = val<BR> end if<BR>end function

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts