Multiple lines per record: Report?

[cjbuechler]

I'm not sure if this is a report issue or if I can get away with it in a query so please bare with me.



I have a user who takes my export from an access query and in excel adds a new line under each record and cuts and pastes some of the fields from the first line into cells on that second line. A lot of manual work. NORMALLY I would make an access report and try to recreate the formatting they used and export that report to excel for them....but I'm using Access 2007 and I no longer have the export to excel option in reports.

I.E...
My export---
Rep Date GL2 Account Fee
Rep Date GL2 Account Fee
Rep Date GL2 Account Fee

What she wants to see in excel---
Rep GL2 Fee
Date Account
Rep GL2 Fee
Date Account
Rep GL2 Fee
Date Account
So, am I totally going about this the wrong way and am I able to do it in a query instead? Is this something that is just going to have to be done in excel anyway and if so is there a faster way than having my user manually add those lines and move the cells?

[RuralGuy]

I believe if you apply Office 2007 SP2 it includes the export to Excel feature again.

[cjbuechler]

Woops, I recall reading a thread about that problem and how the SP fixed it awhile back...totally forgot

Thanks, I can now export to excel but it takes all of my cells and drops them on the same row rather than keeping them stacked on top of each other (2 rows per record with some fields on one and some on another).

Any way to work around that?

[RuralGuy]

What kind of fields are you exporting? What code are you using to accomplish the task?

[cjbuechler]

Plain text fields. I'm hoping to get something like my scenario at the top of the thread. End result would be an excel document where each record has two rows to itself.

I can make a macro to add the extra rows after each record in excel but I'm hung up on moving the fields around to the new row so...

I was hoping I could do that easier in access since thats where the data is coming from anyway.

[RuralGuy]

I'll be honest and say that I have no idea how you would create what you want to export.

[cjbuechler]

Well if you don't know then I'm sure it can't be done. I trust your knowledge on this so I'm going with the idea that Access can't do everything.

Looks like I'll go back to my macro in excel, which can make the extra lines and could probably move the fields for me too but I just don't know how to do that part yet.

Thanks again though for looking into it.

[RuralGuy]

Good luck. Sorry I could not be of more help.