3 Replies Latest reply on Sep 25, 2013 8:02 AM by jhc

    Calculated Fields Confusion

    jhc

      Title

      Calculated Fields Confusion

      Post

           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.