2
2Blessed4Stress
I'm using a form for the user to input a part number exactly as it is. ex. #7-7
I then have a query that runs based on the value entered on the form.
It searches the Description field (text) to find the part anywhere within
the field. How do I structure my query to find the exact part number as
entered with characters? This is what I have in the criteria in my query....
like "*?" &[Forms]![frm_SrchDescForPart]![PartNumber]& "?*"
I then have a query that runs based on the value entered on the form.
It searches the Description field (text) to find the part anywhere within
the field. How do I structure my query to find the exact part number as
entered with characters? This is what I have in the criteria in my query....
like "*?" &[Forms]![frm_SrchDescForPart]![PartNumber]& "?*"