In Oracle I could do the following:

SELECT 1 COL1, 2 COL2, 'TEMP' COL3
FROM DUAL;

This would create a one record temporary table that I could use for various
purposes (mainly for the pipeline in ReportBuilder, supplying user-defined
run-time parameters).

How might I do the same thing if I am using Access 2000??  Is there an
equivalent SQL statement?  If not, what might be the steps I would take??

I am using ADO for this project.

Mike.