[AccessD] Export Queries to Text file

How about creating a union query?

Select Header From query1
UNION Select Details From query2
UNION Select Totals From query3


John V. Ruff - The Eternal Optimist J
 
"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Wednesday, December 28, 2005 10:57 AM
To: AccessD
Subject: [AccessD] Export Queries to Text file

I have three queries I need to export to ONE plain text file to be sent
to one of our benefit providers.

Each query is exactly 1000 characters in width.

The first query has header information, the second is the details, and
the third is totals and other data.

Currently, we're exporting each query then putting them together.

How do you stack query results into a single text file?

 

Thanks in advance.

 

Jim

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com