JuanCarlosSoto Posted January 23, 2008 Share Posted January 23, 2008 How can I get the value of field A on field B on the next record? f.i: today's date (A), and in the next record, in other field (B) to show last day recorded on A...??? please help! Quote Link to comment Share on other sites More sharing options...
touchMe Posted February 10, 2008 Share Posted February 10, 2008 short answer: use a script need more specifics to be more specific Quote Link to comment Share on other sites More sharing options...
LingoJango Posted February 10, 2008 Share Posted February 10, 2008 Do you need this permanently - i.e. you want the latest recorded date - or is the "next record" going to vary according to how you're sorting the records? Try an Auto-Enter calculation of Max ( fieldA ) in your fieldB definition; that might do the trick, assuming fieldA is always entered as the current date. Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.