Home Forums Microsoft Access Microsoft Access Filter in Access- SQL RE: Filter in Access- SQL

  • January 9, 2013 at 1:56 pm

    #1575435

    Hi

    Because you have multiple criteria specified as OR criteria, you need to select District = 1 on each of those criteria.

    There WHERE clause will then look something like the following:

    WHERE

    ((([Austin Police Department].Name) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*") AND [Austin Police Department].District = 1)

    OR

    ((([Austin Police Department].Location) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*") AND [Austin Police Department].District = 1)

    OR

    ((([Austin Police Department].[Phone Number]) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*") AND [Austin Police Department].District = 1)

    OR

    ((([Austin Police Department].District) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*"))

    OR

    ((([Austin Police Department].[Position Title]) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*") AND [Austin Police Department].District = 1)

    I hope this is clear enough.

    Cheers