I am trying to filter my query by the third digit in the following ( "P" & "B")
20P081A
01B020A
I have tried
Like:P
Like:**P
no results
I am trying to filter my query by the third digit in the following ( "P" & "B")
20P081A
01B020A
I have tried
Like:P
Like:**P
no results
Mid function?
Where mid(fieldname,3,1) = "p"
Tick the box
Oh and just realised
Remove the " " from around location.
And is 20p081a a location?
If not use the productID field
Drag down productID, place the mid criteria in that column
Last edited by andy49; 05-21-2017 at 01:52 PM. Reason: Extension
Yes it is a location
Is it location field which has those codes?
Mid([location],3,1) = "p"
They are actually locations in a warehouse
P being a pick from location
B being a reserve location
I need to query both separately from the master inventory file
Got It ! I was missing [] around the field name thanks for your help