Hello.

I have a query, in which i'm trying to select a number that has the value of 'x'. But since the file specs for this particular field has a text value of 20. I tried using trim for this query, to pick out the spaces, but it isn't working. Help!!!

Snoopy92211

This is my query. It's not working! :(

SELECT *
FROM tblsnoopy
WHERE (((trim([blahblah])) In ('123')));

(blahblah is a field in tblsnoopy with a length of 20 but the value is usually only three numbers, as shown in this example)
Thanks a lot.

I believe your WHERE statement is syntaxed incorrectly. Is blahblah an integer field, if so, then no quotes.

"WHERE trim([blahblah]) = 123;"

If not, then..

"WHERE trim([blahblah]) = '123';"

Good Luck.