MS Query and Access Union Query

[Neil-D]

Newish to MS Access and struggling
I have an MS Access with several tables and I have created a Union query (union_Results) that combines them into 1 stacked query. I have then created a list query (qry_Results) that shows all the stacked results.
When I view it in MS Access it works fine, showing all the results OK.
When I go to MS Excel and try to import the query qry_Results in, it is not shown in the list of queries, tables.
All my other queries are there, just not qry_Results.
If I change the source of qry_Results to any other table/query then it appears.

What am I doing wrong?
Thanks in advance for any help.

 

[Neil-D]

Can you post the SQL code of your Union Query?

Do the columns you are returning in it all have the same name?
If not, you may want to try using Aliases to make sure that they all have the same name.
I wonder if they have different names, that is what is causing the issue, as it doesn't know how to refer to each column.

Just a guess...

Good point I hadn't thought of that. The structure is completely the same but the field name may be 'Date Closed' in one table and the other 'Completion Date' in another. I will change aliases so that they are all the same and see if that works. SQL below plus results from Union query and List query

 

[Joe4]

It might not like that ".*" in the Select portion too, not sure.
However, if you are adding aliases, I suppose you will be replacing the ".*" with each field anyhow, so we will see how that turns out.

 

[Neil-D]

It might not like that ".*" in the Select portion too, not sure.
However, if you are adding aliases, I suppose you will be replacing the ".*" with each field anyhow, so we will see how that turns out.

So, made sure all the field have the same aliases throughout each query and then created a union query asking for the aliases instead of *.
Works fine in Access showing stacked results but does not appear in list of queries in MS Query

 

[Joe4]

OK, I am sorry. I guess that wasn't it then. Not really sure then.

 

[Neil-D]

OK, I am sorry. I guess that wasn't it then. Not really sure then.

Thanks for trying, much appreciated.

 

[welshgasman]

If this link does not work, you might have to create a Make Table query from your union query?

Redirecting

Found via import union query from access to excel - Google Search

 

[Joe4]

If this link does not work, you might have to create a Make Table query from your union query?

Redirecting

Found via import union query from access to excel - Google Search

Hmmm... both those suggestions sound vaguely familiar (see post 6 in this thread)!

 

[welshgasman]

Hmmm... both those suggestions sound vaguely familiar (see post 6 in this thread)!

@Joe4 Sorry, not sure we have got to post #18 then?

 

[Joe4]

@Joe4 Sorry, not sure we have got to post #18 then?

What I am saying is that I already made those suggestions back in post 6 (with the exact same link), and they did not want to go the Make Table route (see their reply in post 7).

 

[welshgasman]

I will just let them get on with it then.