Previous record if current does not = specified date

[modglin]

I have a table that gives Qty on Hand by Date. Unfortunately if there are 6 on hand on 1/1/03 and we do not receive or sell any until 1/6/03 the table will only reflect the product on dates that we have changes.
example:
Apples 6 1/1/03
Apples 10 1/6/03
Apples 9 1/7/03
Pears 7 1/1/03
Pears 6 1/2/03
Pears 4 1/6/03

If I need to know Qty on hand for the 1st I would get
Apples 6
Pear 7

If I need to know Qty on hand for the 2nd I would get
Pears 6
Even though we actually have 6 apples on the 2nd they will not show on the report.
What formula(s) would I need that would say if OnHandDate <> DateRan then Qty from the last date available.

 

[chelseatech]

You can use the Previous() function to look at a previous value for a field

I would use a running total and conditonal section supress to display the values you want on the report. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm