2 Replies Latest reply on Sep 10, 2008 1:48 AM by (Colin_Hackett)

    Populate field, based on result of another field

    Level 1
      Hi,

      I'm really new to this, so would like replies to be as simple as possible :)

      I have a field [TotalDays] and would like to populate a field called [DailyRate] with data from other fields [Rate1], [Rate2], [Rate3] or [Rate4] based on the result in [TotalDays].

      Example:
      [TotalDays] = 5
      [Rate1] = $10.00 (if days are 1-7)
      [Rate2] = $ 7.00 (if days are 8-21)
      [Rate3] = $ 5.00 (if days are 22-30)
      [Rate4] = $ 3.00 (if days are 31+)

      Therefore [DailyRate] would populate with the amount $10.00

      I hope this makes sense???

      Greg