Crosstab query with changing column headings

[Allen the Computer Guy]

I have a crosstab query that compiles a list of expenses for the current
month and the previous two months. After the first of next month, the 3
column headings will change. When I tested that by changing the formula i
used to create the crosstab query, the report couldn't find one of the
columns. How do i setup the report to use the three columns, regardless of
what the column headings are?

 

[Duane Hookom]

There is a solution for dynamic monthly crosstab reporting at
http://www.tek-tips.com/faqs.cfm?fid=5466.

 

[Allen the Computer Guy]

At first it didn't make sense. I had looked at that website and still
couldn't figure it out, so i dismissed it. Once I knew the answer was in
there, i searched for other posts that had gotten the same answer. I figured
there was probably someone else that was confused as I was. I was right. I
found a thread from a month ago where you explained it over and over again.
Between that and 5 hours of sleep, I got it figured out. Thanks for being
there.

 

[javablood]

,Duane,

After sitting down and going through the tek-tips and your posts (lots of
them) on this subject, I got it to work!. That's the good news! However,
the bad news is that my dates are not divisible by week, day, month, or
quarter such that DateDiff will work. So when I use DateDiff for quarter
only those dates (if they exist) in exact 3 month increments will work. Is
there anyway to do something similar but take the dates selected in the form
to capture in the report from the query?

Thanks

 

[Duane Hookom]

My solution works only with specific consistent date/time intervals. I have
some other crosstab report samples at www.RogersAccessLibrary.com that work
for dynamic column headings.

 

[javablood]

Duane,

Thanks. I have used your Crosstab database as a guide to getting my report
to work. However, I have a question and have started a new thread.