Exclusion of *

[dgriffis1231]

I am doing a crosstab query and would like to exclude all the titles with the character * in it. However, access seems to get confused when I type Not Like "*".

Thank you,

DG

 

[David R]

With good reason, given that * is a reserved symbol.

Try something like (assuming this is a text field)

Not Like "*[*]*"

 

[redalert]

I am assuming that 'titles' is a field.

Use the ASCII character code Chr(42) in the criteria as this may work.

SELECT titles FROM tablename WHERE (((InStr([titles],Chr(42)))=False));

 

[dgriffis1231]

Thanks guy(s) and or girl!