Re: How do I get dummy values from a UNION statement?

[Ken Snell [MVP]]

Yes, you can do this in ACCESS. What have you tried?

 

[Ken Snell [MVP]]

Is Dual the name of a real table? You need to use the name of a real table
in the first SELECT statement.

 

[John Vinson]

In other databases, when you try to get a dummy value to include it as I am
trying to do, you have to use a special dummy table.

Access does not have such a dummy table. However, you can create a
one-row, one-field table named Dual yourself; your query should then
work.

John W. Vinson[MVP]
(no longer chatting for now)

 

[Guest]

I have been using a union query
SELECT *
FROM [BARBARA WIP]
WHERE [IS THIS A CONTRACT?]=YES
UNION
SELECT *

 

[Guest]

I have been using a union query with the below statements. I want to know if
there is another way around joining these two tables for the column where Is
This A Contract=YES
Currently I'll be asked to change/add a column to the table and the union
query doesn't update; therefore I will have to rebuild the queries and
reports based off this union query. Thank you.

SELECT *
FROM [BARBARA WIP]
WHERE [IS THIS A CONTRACT?]=YES
UNION
SELECT *
FROM [SARA WIP]
WHERE [IS THIS A CONTRACT?]=YES