Union Query

[DZ]

Hello

..What I am trying to do.

I am creating a Union query from several tables. Some of the tables referred
to in the UNION Clause are missing some of the fields that are present in the
SELECT clause, so I am generating dummy field names so that the UNION Query
will work.

The UNION query works fine and the data output is correct as far as I know,
but the "Enter Parameter Value" dialog opens for every missing field
everytime I run the query.

What I need help with is:

Is there a way make Access NOT display the "Enter Parameter Value" dialog
when I run a Union Query. The Union Query displays the "Enter Parameter
Value" dialog because there are dummy field names in some of the tables in
the UNION clauses

This is a workaround so the UNION Query will works, because I do not want
to the missing add fields to the underlying tables.

If you can suggest either
1. A way to NOT display the "Enter Parameter Value" dialog box

or

2. better way to deal with the missing fields in a Union Query

That would be very helpful

DZ

 

[Duane Hookom]

Providing a value for a missing column normally doesn't cause parameter
prompts. You can simply replace a field/column with a value like Null or 0 or
" " depending on what you want in the column.