Dymanic Cross-Tab Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oscar - 03 Jul 2006 02:53 GMT

I am trying to create a cross-tab report that is updated every week to
show data from the past 90 days. Along the left column I have location
number and for the column headings I have week ending date. I am
trying to track the amount each location spent on salaries for the most
recent 90 days. However, I would like this report to dynamically
change so I don't have to update it every week, ie. the oldest entry
expires off the page in 90 days and the newest is replaced. I have
read every search result in these threads, downloaded numerous examples
and for some reason I still don't understand. I'm kind of a beginner
at this so any step-by-step instructions for a novice would be very
helpful. Thanks,
Oscar Brown

Reply to this Message

[MVP] S.Clark - 03 Jul 2006 04:26 GMT

With all of that research, you must be near the finish line.

List your Row, Column, & Value entries. Also, if used, list your
ColumnHeadings property value.

Signature

Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

>I am trying to create a cross-tab report that is updated every week to
> show data from the past 90 days. Along the left column I have location
[quoted text clipped - 8 lines]
> helpful. Thanks,
> Oscar Brown

Reply to this Message

Oscar - 03 Jul 2006 05:17 GMT

Steve,
The Rows are [Center No] and their respective [Center Name], the column
headings are [Week Ending Date] and the Value is [Labor $]. I'm not
quite sure what a Column heading property value is. It's in the form
of a date if that helps.
Thanks!
Oscar

> With all of that research, you must be near the finish line.
>
[quoted text clipped - 20 lines]
> > helpful. Thanks,
> > Oscar Brown

Reply to this Message