Retrieve the table names from union query.

		Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Retrieve the table names from union query.

Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

July 20th, 2005, 01:38 AM

udayanbi

Registered User

Join Date: Jul 2005

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Retrieve the table names from union query.

I am unable to retrieve the table names from a union query. When i am searching in the msysqueries table with the specified query name, i am getting something like " X&YZ____1", and hence unable to resolve the tables involved in the query. Please provide me the solution as i have to meet the deadline.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
UNION QUERY Help	Corey	Access	1	October 27th, 2006 05:29 PM
UNION query.	rupen	Access	3	April 28th, 2006 02:49 AM
how to Retrieve Column Names Using SQL Query	saravananedu	Oracle	2	September 10th, 2005 01:57 AM
How to Retrieve Table Names using ADO	ramk_1978	ADO.NET	1	October 22nd, 2004 08:19 AM
Error on Make-Table Query In Union Query	rylemer	Access	1	August 20th, 2003 07:42 PM