Help with Instr() function

[dridgeway]

I have a parameter query that prompts:
[Enter Freight Terms]

User needs to be able to enter single or multiple values (seperated by commas)

Freight Terms is a 3 character field with only 3 different values: P, PA & C - however if I enter PA, I receive all the P's and the PA's...how can I avoid this? Both have the letter P as the starting character.

Here's my SQL statement:
SELECT DPL.LOAD, DPL.PRECOL3RD
FROM DPL
WHERE (((InStr([Enter Freight Terms],[DPL].[PRECOL3RD]))
Is Null Or (InStr([Enter Freight Terms],[DPL].[PRECOL3RD]))>0));

 

[JoeAtWork]

Couldn't it just be:

SELECT DPL.LOAD, DPL.PRECOL3RD
FROM DPL
WHERE DPL.PRECOL3RD = [Enter Freight Terms]

 

[dridgeway]

I need the user to be able to select multiples, P & PA, or P & C, C & PA....etc.

 

[JoeAtWork]

All the possible variations make it virtually impossible to code inline in the SQL statement.

I would make a multi-select listbox with C, P, and PA, then build the WHERE clause from what was selected in the listbox.

 

[dridgeway]

I ended up doing this:

((InStr(" & strFreight & ",format([DPL].[PRECOL3RD],'!@@@')))>0 Or (InStr(" & strFreight & ",format([DPL].[PRECOL3RD],'!@@@'))) Is Null)

StrFreight is just an entry box on a form - but works with miltiples now with commas

Thank you