Access 2000 Query

Results 1 to 2 of 2

Thread: Access 2000 Query

  1. #1
    Join Date
    Dec 1969

    Default Access 2000 Query

    I have an Access 2000 front end for my SQL 2000 database.<BR>One of the fields is:<BR> NullCheck: isNull(CompanyName)<BR><BR>this returns a lot of 0&#039;s and -1&#039;s, however if I try to add to the critera 0 or -1, all the records still come back. I have tried lots of ways to filter these out and cant figure where I&#039;m going wrong.<BR><BR>Thanks<BR>Steven Simpson

  2. #2
    Join Date
    Dec 1969

    Default RE: Access 2000 Query

    where NullCheck = true<BR><BR>(Or, alternatively, you may need to do):<BR>where isnull(companyname) = true<BR><BR>And, this would work:<BR>where companyname is null

Posting Permissions

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