[AccessD] Export Queries to Text file

I would think that you could use a union query if each query has the same
number of fields.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Wednesday, December 28, 2005 1:57 PM
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