Using a cookie in a custom SQL in database wizard

[RonTev]

I want to retrieve data from an access database where a
cookie value is used in a custom query. In the following
attempt I get a "data mismatch" error. DN is a numeric
field in the database; CDNum is a cookie with a numeric
value (or, it is supposed to be ...when setting a cookie,
is there a way to be sure it is numeric??)

SELECT * FROM assigned WHERE (DN = request.cookies("CDNum")')

Alternatively, are there a couple of lines of ASP which
would declare a variable, containing the cookie value,
which would then be visible to the Database results wizard
- the same way it sees variables from the POST method
usually used??