I have done this before, but can't seem to remember how.



I need to do a filter on a field where it begins with one of three letters.



I tired something like this:



[strWE/AFE] LIKE (W, E, N)



I am sure it is just a syntax error.  I need it where field strWE/AFE 

startes with either a W E or N.



Thanks

The filter property of your report should look like this:



[strWE/AFE] like "[W,E,N]*"



Note the square brackets and the '*' wildcard.



You also need to ensure that the 'Filter On' property is set to 'Yes'



Brian



> I have done this before, but can't seem to remember how.

> 

> I need to do a filter on a field where it begins with one of three letters.

> 

> I tired something like this:

> 

> [strWE/AFE] LIKE (W, E, N)

> 

> I am sure it is just a syntax error.  I need it where field strWE/AFE 

> startes with either a W E or N.

> 

> Thanks