Aug 25 2005, 04:43 PM
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!
Aug 25 2005, 05:42 PM
how about using a query?
are you wanting the final output to be rows and columns?
do you have groups and subtotals?
Aug 26 2005, 10:17 AM
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.
Aug 26 2005, 01:13 PM
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.
Aug 26 2005, 01:40 PM
Here is the link to the file: http://184.108.40.206/search?q=cache:7TqW5...ports&hl=en
and the file itself is attached. Found it @mvps.org it's the work of Pierre Tessier.