make table with union query

[Richard]

Hi

Am I able to create a table with union query?

I need to create a temp table from the union query, add a yes/no field. This
is to let the users check which record they want and export the record to
word. Can users check a record from a union query. (I now have a continuous
form based on the union query)

Should I do it this way or is there a better way? Hope you understand what I
am trying to achieve here.

Thank you in advance
Richard

 

[Douglas J Steele]

Yes, you can create tables with Union queries. Save the Union query, and use
it as the basis for a Make Table query.

No, Union queries are not updatable, so you won't be able to have your users
check a record from a Union query.

 

[Richard]

Thanks Doug for the advice

Richard

Yes, you can create tables with Union queries. Save the Union query, and use
it as the basis for a Make Table query.

No, Union queries are not updatable, so you won't be able to have your users
check a record from a Union query.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


what