If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
reporting plain text files
I have found out how to do the report I want, but I can't
seem to find how to supress newlines in the report. Can you do this (specifically for the export of a report)? If now how do people usually export data into application specific CSV files that have both static data and data generated data included? |
#2
|
|||
|
|||
reporting plain text files
Usually the simplest way to export table fields + calculated fields is to
create a query, and use TransferText to export to CSV. If you have not created calculated fields in a query before, it is just a matter of typing an expression into the Field row, e.g.: Amount: [Quantity] * [UnitPrice] More information: Calculated fields at: http://allenbrowne.com/casu-14.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Derald" wrote in message ... I have found out how to do the report I want, but I can't seem to find how to supress newlines in the report. Can you do this (specifically for the export of a report)? If now how do people usually export data into application specific CSV files that have both static data and data generated data included? |
Thread Tools | |
Display Modes | |
|
|