Possible to format a query/report off of this?

  • Thread starter Thread starter Juan Schwartz
  • Start date Start date
J

Juan Schwartz

I have can have the report group by date and rep and have it repeat the
Key Indicators over and over, but I'd like it to have 7 columns for
each day of the week(Mon-Sat) and one for totals and have it come out
looking similar to this....

http://buyitused.net/screenshot.png

Each day has 3 numbers for each of the 22 indicators... Plan, Actual
and Variance.

I have the data and queries, but I don't know how to format the report
OR query to get the desired result in the screenshot of the sample
report given to me.

Any help or link to good tutorials on this subject would be appreciated
:)
 
With each day having a seperate query and a seperate report for each
day and the total?

IE, have a form set the first day of the report and save the queries as
[date], [date]+1, etc.?
 
Back
Top