
August 3rd, 2005, 05:27 PM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 16
Time spent in forums: 11 h 19 sec
Reputation Power: 0
|
|
|
Export Access Report to text file difficulty
I am trying to export a report from Access 2k to a fixed width text file with several problems. This is for an interface with a bank on-line reconciliation program and I need to have a fixed header, details for account #1, footer for account #1 (containing a count of transactions for that acct and total sum of transactions for that acct), then detail for account #2, then footer for acct #2, etc.
I previously attempted to put just an unbound text box on the report in the detail section then export just the detail to text file. But when I checked the text file, it has 3 records then a blank line. Any ideas what is causing this?
Second question, does a text box that is not visible on a report have that data transferred to the text file. (I was thinking I could have a hidden field with check number and transaction amount so that I could summarize on those fields.) If someone else has some ideas - I'm getting desperate and frustrated. I'm supposed to start the actual testing with Wells Fargo on Monday.
Thanks!
Nadine
|