SQL In Statement with Variables?

Is it possible to create a SQL In statement using variables?

For example, here is what can be done:

SELECT Test.ID, Test.Desc
FROM Test
WHERE (((Test.ID) In (3,6,9,12)));


But, I would like to do something like this:

SELECT Test.ID, Test.Desc
FROM Test
WHERE (((Test.ID) In ([@[EMAIL PROTECTED]
)));

( I have a loop that will be passing the: 3,6,9,12 )

However, it does not work.  Am I missing something in the syntax or is
it I cannot do it this way?

Any thoughts and or advice is greatly appreciated.

Ray