Dymanic Cross-Tab Report

[Oscar]

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

 

[[MVP] S.Clark]

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.

--
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

 

[Oscar]

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