How do I generate an ASCII report from access?

Y

Yogioz

I need to generate a report from an Access databse (for banking purposes).
Can anyone help/point me in the right direction?
 
A

Allen Browne

See help on:
OutputTo
or if you want to set it as an email:
SendObject

Outputting a report like that can result in blank rows, and headings that
interrupt the flow of data into somewhere else, so it might be better to
use:
TransferText
on the table or query that feeds your report.
 
Y

Yogioz

Thanks - can these be used directly from the query? ie rather than generate
a report from a query output the results of the query to an ASCII file?
 
Y

Yogioz

Thanks - can these be used directly from the query? ie rather than generate
a report from a query output the results of the query to an ASCII file?
 
A

Allen Browne

Sure. You can open the query (in datasheet view) and choose Export on the
File menu.

Or create a macro with the TransferText action if you want to do it from a
command button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Number sequences 0
Delete 100 Hundred Unique Values From Word Document 0
How to make report 0
Multiple animations 0
Global layouts 0
Extract all attachments from all received Outlook 365 (on my PC) emails to a Folder 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0

Top