|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 7th, 2007, 07:35 PM
posted to microsoft.public.access.reports
|
|||
|
|||
%Chg YTD vs LYTD
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. 
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
