Hey there, I can't seem to get a handle on formatting reports to look as close to the way I format the same info in Excel.

I don't mind racking my brain, but I just wanted to see if anyone had some quick fixes or suggestions. Thanks!

how about using a query?

are you wanting the final output to be rows and columns?

do you have groups and subtotals?

I'm pretty sure I've got the query(s) set up correctly, and should be able to adjust them accordingly. The only thing is finding a way to apply the asthetic formatting (color, layout, conditional formatting, scaling to page) all automatically.

I haven't yet started digging in today, but that's next on the list.

I know there are posts in the archives about this -- I will look later. If you find something, please let me know so I don't look too.

Greetings,

Here is the link to the file:

http://64.233.167.104/search?q=cache:7TqW5...ports&hl=en


and the file itself is attached. Found it @mvps.org it's the work of Pierre Tessier.

thanks, David