I have a report that I created in Access that contains a total of 8 fields. The layout of the first 7 fields are columnar across the page. The 8th field is on the next row and contains user entered notes. The field width of the 8th field is equal to the width of the entire first row.
Example:
Field1 Field2 Field3 Field4 Field5 Field6 Field7
F----------I------------E----------L--------D--------8
So, 50 records require 100 lines on the report. When I try to export the report to Excel, my 8th field is on the same row as fields 1-7, instead of being on a new row.
When I export the report to Excel, I get all 8 fields on one row. I then have to insert a row between each record, merge the cells and copy and paste the data in the 8th field for each record.
I hope this makes sense...can anyone help?
Example:
Field1 Field2 Field3 Field4 Field5 Field6 Field7
F----------I------------E----------L--------D--------8
So, 50 records require 100 lines on the report. When I try to export the report to Excel, my 8th field is on the same row as fields 1-7, instead of being on a new row.
When I export the report to Excel, I get all 8 fields on one row. I then have to insert a row between each record, merge the cells and copy and paste the data in the 8th field for each record.
I hope this makes sense...can anyone help?
Comment