URGENT:how to fix the query must have at least one destination field error

[elly.khanlar]

Hi All,

I am trying to make a master list by joining two tables based on the "Source" and "material" field.

this two table that I am trying to join are the result of creating make table from union queries by writing following code:

qryTable123:
SELECT * FROM Table1
Union All
SELECT * FROM Table2
UNION ALL SELECT * FROM Table3;

qmktNewTable:
SELECT qryTable123.* INTO NewTable
FROM qryTable123;


Now, I am getting this error" Query must have at least one destination field" when I tried to join the two tables that are the result of make table from union queries. I check the design grid for the make table from union queries, and both have field in the design grid. Could you please help me solve this issue.

 

[theDBguy]

Hi. Just a guess but try it out without the table name. For instance:

SELECT * INTO NewTable FROM qryTable123

Hope it helps...

 

[arnelgp]

then do what it is asking, specify the fields you want to get:

select field1, field2[, fieldX] into NewTable From qryTable123;

 

[elly.khanlar]

Thanks for your response.
I got this error message again while making a select query of two tables.

First 10 fields i chose in design grid are from table A, and the rest are from table B by computing with one fields from table A. I realized that I needed to change the name of one of the field of table B. So i changed the name field in the table and saved it. so i tried update query to use updated one, now I get the error message that says "query must have one destination field. Could you please help me?

 

[June7]

SELECT * INTO NewTable FROM qryTable123 worked for me (so does using table name prefix).

Since you are using wildcards for fields, changing field name in table should not cause issue. Don't see why an UPDATE action would be necessary.

Does UNION query open?

If you want to provide db for analysis, follow instructions at bottom of my post.

 

[elly.khanlar]

no, the union query is closed

 

[June7]

I mean will it open without error after you made this field name change?