Start of field Query

[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.

 

[hcj]

Hi Nikki,
In Criteria enter:
Like [Prefix? Leave blank for all]&"*"