Use of "INTO" clause in a "SELECT" SQL Statement?

[tigreeuropeo]

Hi!!!

I have a very simple table of products, identified by a reference number:

Reference Text
Description Text

I need to retrieve the description of one product, but I don't know how to use the INTO clause in a SELECT statement.
In many other programming languages the use would be:

SELECT Description INTO <host variable>
FROM Products
WHERE Reference = &quot;123456&quot;

The host variable (without the brackets) should be a string of our code in Access. Is it possible to do that?.
Thanks.

 

[tomschafer]

The INTO clause is used to make a new table. Try this...
SELECT <host variable>=Description
FROM Products
WHERE Reference = &quot;123456&quot;