Exact Match Query

[KCC47]

I need some assistance with an exact match query for FEIN_SSN field in the Application_Tbl. I've built a search query for Business_Name and Local_Account_Number, and those work just fine. Those are in the Application_Search_Qry, and the form that runs the query is Application_Search_Frm. The FEIN_SSN search simply will not work.



Thank you.


Application_Log_Db.zip

[rpeare]

you are using like in your criteria

Like "*" & [Forms]![Application_Search_Frm].[Query_FEIN] & "*"

If you want an exact match it has to be

[Forms]![Application_Search_Frm].[Query_FEIN]