Start of field Query

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

Is there a line you can add to this code
WHERE (((InStr([table seperated by commas,Blank=All],
))>0 Or (InStr([table seperated by
commas,Blank=All],
)) Is Null))

That will allow you to search for the start of the field
as well. Say I have several product numbers that start
with 3467_ _ _ the last numbers then distiguish between
dates they were used.. so I want to find all the product
numbers that start with 3467. I know this can be done in
a simple query using an * , but I want the dialogue box
query so that the product number can change.
 
Back
Top