Report Format

J

Jennifer Mundle

I am trying to make my report look like this (see Below)

Weekending: 7/02/04 7/09/04 07/16/04
Product A $$$$$ $$$$$$ $$$$$$
Product B $$$$$ $$$$$$ $$$$$$
Product C $$$$$$
Product D $$$$$$
Product E $$$$$$

My Problem is My Report is looking like this

Weekending: 7/02/04 07/09/04 07/16/04
Product A $$$$$$ Product A $$$$$ Product A $$$$$$$
Product B $$$$$$ Product B $$$$$ Product B $$$$$$$
Product C $$$$$ Product D $$$$$$$
Product E $$$$$$$

How do I get all my Product to the Left leaving the
Weekending data and the dollar values under the weekending
date.
 
F

Fons Ponsioen

Without knowing how your data is organized I would
recommend to look at using a pivot report:
You need to have your data organized like:
Product WeekEnd Cost
A 7/2/04 $999
B 7/9/04 $77

etc:
Hope this helps.
Fons
 
F

fredg

I am trying to make my report look like this (see Below)

Weekending: 7/02/04 7/09/04 07/16/04
Product A $$$$$ $$$$$$ $$$$$$
Product B $$$$$ $$$$$$ $$$$$$
Product C $$$$$$
Product D $$$$$$
Product E $$$$$$

My Problem is My Report is looking like this

Weekending: 7/02/04 07/09/04 07/16/04
Product A $$$$$$ Product A $$$$$ Product A $$$$$$$
Product B $$$$$$ Product B $$$$$ Product B $$$$$$$
Product C $$$$$ Product D $$$$$$$
Product E $$$$$$$

How do I get all my Product to the Left leaving the
Weekending data and the dollar values under the weekending
date.
Click to expand...

See if the following Microsoft KnowledgBase article helps:
210044 "ACC2000: How to Print Labels on the Left Margin of a Report"
 
Top