Rick- Not sure what you mean by "unable to save it to the desired field." You can write a small VBA procedure in the AfterUpdate event of the LastEval field to calculate and set the NextEvalDue field. Let's say the next eval is due in 90 days. You're code would look like:
Private Sub LastEval_AfterUpdate() Me.NextEvalDue = Me.LastEval + 90 End Sub John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Danzey Sent: Sunday, October 23, 2005 12:34 PM To: [email protected] Subject: [ms_access] Calculated field I'm fairly new to access. I have a DB created for HR activity. Several fields need to be calculated based on an entry in another field ie, [LastEval] entry to calculate field [nextevaldue] in one year. My desire is to of course have all next due dates calculate automatically. I can do it in the form view but unable to save it to the desired field. There has to be a simple solution. Your help is greatly appreciated. ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
