Access Query Criterion

Access Discussion in 'Microsoft Office' started by John Hein, Feb 12, 2018.

  1. John Hein

    John Hein

    Joined:
    Feb 12, 2018
    Likes Received:
    0
    HAVE A QUERY THAT CONTAINS 3 FIELDS. NAME, MOBILE, AND E-MAIL.
    I WANT TO SET A CRITERIA THAT WILL SELECT ONLY THOSE RECORDS THAT CONTAIN DATA IN THE MOBILE AND E-MAIL FIELDS.
     
    John Hein, Feb 12, 2018
    #1
    1. Advertisements

  2. John Hein

    msbad

    Joined:
    Mar 14, 2018
    Likes Received:
    0
    SELECT fldname1, fldname2, fldname3 FROM Table1 WHERE fldname2 Is Not Null AND fldname3 Is Not Null;
     
    msbad, Mar 14, 2018
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.