Access filter use

[doug33]

I created a filter for a column of four digit numbers (SIC codes). Can I
copy the filter for a column of eight digit numbers using the "begins with"
filter command? If so, how?

 

[Keven Denen]

I created a filter for a column of four digit numbers (SIC codes).  CanI
copy the filter for a column of eight digit numbers using the "begins with"
filter command?  If so, how?

In your criteria, use the LIKE keyword. So you'd use LIKE "1234*" or
LIKE "[Choose SIC]*". The LIKE keyword allows the use of wildcard
characters * and ?. * meaning replace any number of characters, ?
meaning replace 0 or 1 character.

Keven Denen

 

[doug33]

I created a filter for a column of four digit numbers (SIC codes). Can I
copy the filter for a column of eight digit numbers using the "begins with"
filter command? If so, how?

In your criteria, use the LIKE keyword. So you'd use LIKE "1234*" or
LIKE "[Choose SIC]*". The LIKE keyword allows the use of wildcard
characters * and ?. * meaning replace any number of characters, ?
meaning replace 0 or 1 character.

Keven Denen

Thanks
In my case, the filter included over 40 distinct four digit codes. So even
if I use your approach, I will need to list them. What is the accepted
expression for a list like that in a filter command? Commas? Space(s)? And
can they just be listed without quotation marks for each (e.g.,
1234,2598,3761)?