previous year value

[sirtemplar]

how do i put in a field its value the previous year? my database is like this:

year - number field

name - text field

income - number field

income 2 - number field

income is the present year, i want income 2 to contain income of previous year

thanks

[Stuart Taylor]

Take a look at this.

lastyear.fp7.zip

[RobinG]

Or a slightly different way that I prefer (see attached)

Previous.zip

[Natalie]

I like that. :

[Stuart Taylor]

Depends whether you want to return the results for the last year or last year entered.