AnsweredAssumed Answered

Calculated Fields Confusion

Question asked by jhc on Sep 24, 2013
Latest reply on Sep 25, 2013 by jhc


Calculated Fields Confusion


     I'm new to all of this and easily confused at the best of times. 

     I'm trying to create a field that is based on the values of 2 other fields. I thought this would be a calculated field. I have tables for lakes (including lake names), and visit date. I was hoping to create a calculated field from those two to make something like "Big Lake August 2013".

     So my formula looks like LakeName + " " + MonthName ( StudyDate ) just to test it out. When I enter Lake Name the calculated field already puts the name in, without anything in the month field yet. When I enter something in the month field nothing happens. When I change the lake name to something else, the calculated field still does not change. 

     Can we control when the calculated field actually calculates? I want it to do that when it's over not when I'm in mid-data-entry.