K

#### kritter0021

in Access: so 3/29/08 in cell A1 and 5/3/08 in cell A2 and return the value

in B1 of 35. How do I do this? Thanks!

In Excell the formula looks like this:

=IF(+A1-A2>0,A1-A2,0)

Here is some data which may help. Thanks!

Here is the data that my query looks like and Dif Date is what I want

calculated. I think I need to number each record. How do I do that, so just

1,2,3,4.... Once I have them numbered then it can look at previous record.

I don't know. Maybe...Thanks.

Product Date Dif Date

A 1/23/2009 40

A 3/4/2009 65

A 5/8/2009 0

B 3/2/2009 28

B 3/30/2009 0

Text Date Number

I am wanting to calculate the Diff Date and when it moves to a new product

display the average of of the product, so instead of displaying 0 show the

average of A of 52.5. Not sure if this is possible. Real easy in excell.