query with inline dummy table

[jasontferrell]

Is there a way in Access to create a query that contains the table
records within the query itself? I want to avoid creating a dummy
table and just use values within the query definition. I was thinking
about using syntax similar to the insert into statement I would use to
populate the dummy table, but I'm not sure if I have a syntax problem
or I'm trying to solve an impossible problem.

The query I'm thinking of might look something like this:

select *
from values("test");

-or-

select *
from (
("1/1/07","2/1/07","3/1/07","4/1/07","5/1/07","6/1/07")
);