Access 2000 design question

[Danny]

Greetings,

I start creating the attached access db to simplify the data entry process currently done using Excel. We also purchased a third party application (for data definition purposes) that allows us to import what we already have in place. But, in order to export to the third party application:

1. It’s limited to 10 fields
2. The file has to be in CSV format

Since we’re limited to 10 fields, we currently input multiple fields in a single cell and use save as CSV for export.

What design changes do I need to make in Access to include everything I have in my (frmDataEntry2) so I can create a report that I can export as CSV?

TIA,

Regards

 

[jdraw]

When you cross post, please advise the readers that you have done so.

Cross posted at http://www.accessforums.net/access/design-question-41035.html

Please see this note about cross posting