Report Formatting

[PraizesLiberato]

I have set the report format in a certain way but the OutputTo command when used to export into an excel sheet it gives me a totally different view. there are 2 images below

1) Excel View of the Report
2) MS Access Design View of the Report

to describe the same.

As you can see everything is out of order and needs to be in order. im kinda new at reports but would be really helpful if you could assist on the same. thanks.

I have reomved a few descriptions so please forvive me if the images arent too clear.

 

[Trevor G]

Look to use a macro to transferSpreadsheet.

If you are using Access 2007 then when you create a macro you need to tell it at the top to show all commands

 

[PraizesLiberato]

but ive tried this with another report and others have done it preserving the formatting i dont understand y this only doesnt work. oh well i'll try again tomorrow morning ...D DAY.