Question about Union Query

[emandel]

Is there any way to allow me to edit information in a union query? In other words can I update information from within this query? For some reason it doesn allow me to change any information in the datasheet view of the query.

[HTML]SELECT [Last Name], [First Name], [e-mail]
FROM [From Old List]
WHERE [E-MAIL] is not null

UNION SELECT [Last Name], [First name], [e-mail]
FROM [participants]
WHERE [E-MAIL] is not null
ORDER BY [last name];[/HTML]

[Jim Doherty]

Is there any way to allow me to edit information in a union query? In other words can I update information from within this query? For some reason it doesn allow me to change any information in the datasheet view of the query.

[HTML]SELECT [Last Name], [First Name], [e-mail]
FROM [From Old List]
WHERE [E-MAIL] is not null

UNION SELECT [Last Name], [First name], [e-mail]
FROM [participants]
WHERE [E-MAIL] is not null
ORDER BY [last name];[/HTML]

The short answer is no union queries are uneditable

Jim

[emandel]

The short answer is no union queries are uneditable

Jim

Is that true even if I create another query based on that query? or isn't there a way to create a new table from a query?

[Jim Doherty]

Is that true even if I create another query based on that query? or isn't there a way to create a new table from a query?

You can create a new table directly from the union query sure.

The syntax for that assuming your union query is called qryMyUnion would be:

 
SELECT [Last Name], [First Name], [e-mail] INTO MyNewTable
FROM qryMyUnion;

Go into query design simply add your union query to the design grid and
switch the query type to 'Make Table'

Obviously once its into this new table it becomes editable. The INTO bit practically speaking is the 'Make Table' query element of Access and thus the table is automatically generated.

Regards

Jim :)