July 9, 2012 at 12:01 pm
i have 1 field in my query ,which i ma putting in reporting.
what i want to do is ,if in 1995 this field has value 1000, and then in 1997 it has 23
then when i am putting in report
it shows me like 1000 and then again back to 0, till it reach to 1997 .
i want it to hold the value 1000 from 19995 untill 1997 ,and when it reach to 1997 it should 1000+23
any idea?
July 9, 2012 at 12:08 pm
I'm not sure I understand the question. But, based on what it seems to be asking, can you create a table of years and the value you want for each year?
Year Value
1995 1000
1997 1023
Like that, in a table.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply