CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: Access Query

  1. #1
    Join Date
    Oct 2003
    Posts
    133

    Access Query

    I need to query a field to findout if it has the word "McAfee" or nothing at all. I can get it to look for McAfee or something else, but I'm stumped on looking for blank records.

    Any ideas?

    Thanks

  2. #2
    Join Date
    Jun 2001
    Location
    Mi
    Posts
    1,249
    SELECT * FROM MyTable WHERE IsNull(MyField);

  3. #3
    Join Date
    Feb 2003
    Posts
    78
    To be a bit more specific

    Select * from Table
    where fieldToQuery = 'McAfee'
    OR fieldToQuery is null
    OR fieldToQuery = ''


    Last one is to check for empty string.

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured