sirtemplar Posted September 16, 2007 Share Posted September 16, 2007 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 Link to comment Share on other sites More sharing options...
Stuart Taylor Posted September 16, 2007 Share Posted September 16, 2007 Take a look at this. lastyear.fp7.zip Link to comment Share on other sites More sharing options...
Newbies RobinG Posted September 16, 2007 Newbies Share Posted September 16, 2007 Or a slightly different way that I prefer (see attached) Previous.zip Link to comment Share on other sites More sharing options...
Natalie Posted September 16, 2007 Share Posted September 16, 2007 I like that. : Link to comment Share on other sites More sharing options...
Stuart Taylor Posted September 17, 2007 Share Posted September 17, 2007 Depends whether you want to return the results for the last year or last year entered. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6157 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now