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

  • January 11, 2013 at 1:36 am

    #1576111

    Hi, what happens if you use

    WHERE [Austin Police Department].District = 1 AND ((([Austin Police Department].Name) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*")) OR ((([Austin Police Department].Location) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*")) OR ((([Austin Police Department].[Phone Number]) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*")) OR ((([Austin Police Department].[Position Title]) Like "*" & [Forms]![Austin Police Department- District 1]![txtSearch2] & "*"))

    ?