B
Bill Phillips
This is a followup to my 4/24 post of YTD Calc in Footer. I was able to
modify the function referenced to give me a YTD in the footer. What I want to
do is compare my current YTD to Last years YTD (So I am comparing Sales
through 5/07 to sales through 5/06) I have 2 unbound text boxes in my footer,
1 for 2006 sales tyd (txt2006YTD) and 1 for 2007 sales YTD (txt2007YTD). I
think the problem is that my report cycles at least 2 times, so if I have
sales information for both 2006 and 2007, the value in txt2006YTD is
overwritten with a null value.
I though I could use some sort of domain min or max, but I really don't know
how to structure it. Any help is greatly appreciated.
modify the function referenced to give me a YTD in the footer. What I want to
do is compare my current YTD to Last years YTD (So I am comparing Sales
through 5/07 to sales through 5/06) I have 2 unbound text boxes in my footer,
1 for 2006 sales tyd (txt2006YTD) and 1 for 2007 sales YTD (txt2007YTD). I
think the problem is that my report cycles at least 2 times, so if I have
sales information for both 2006 and 2007, the value in txt2006YTD is
overwritten with a null value.
I though I could use some sort of domain min or max, but I really don't know
how to structure it. Any help is greatly appreciated.