Field = Next Record's Field Value

[Climbo]

Hello there,

I have a sorted DB that contains a phone #, a create Date, a blank Expiry date and an order #:

phone# Create_Date Expy Date Order #
1111111111 2009/10/03 QWE23
2222222222 2009/10/05 QWE43
2222222222 2009/10/09 QWE54
2222222222 2009/10/12 QWE76
3333333333 2009/10/06 QWE87

is there a way to right a query so that when it finds the same phone #, it populates the Expiry date with the "Create date -1" of the next record?

the result DB should give:

phone# Create_Date Expy Date Order #
1111111111 2009/10/03 QWE23
2222222222 2009/10/05 2009/10/08 QWE43
2222222222 2009/10/09 2009/10/11 QWE54
2222222222 2009/10/12 QWE76
3333333333 2009/10/06 QWE87

I could do it in VBA code but wondering if there is a way to do it in a query...

thanks.

 

[pbaldy]

Is this what you're looking for?

http://www.baldyweb.com/PrevValue.htm