2 Replies Latest reply on Dec 7, 2014 1:11 PM by eqitec

    Finding Records Using a Concatenated Text Field

    eqitec

      I need to find records via selection from a value list for a calculated (indexed)
      text field derived by the following concatenation of 3 fields:

       

      Field 1: Date (originally formatted as date)
      Field 2: Location (originally formatted as text)
      Field 3: Event# (originanally formatted as numeric)

       

      The calculated text field is shown below:

       

      GetAsText(Date) & "-" & Location & "-" & GetAsText(Event#)

       

      Here's an example of one such record: "12/7/2014-NJ-1"

       

      The script to find any one such record works fine via selection from a value list for the
      concatenated field except for when finding records with an event # = a single digit,
      when there are other higher event #s with that same single digit as one character of the
      higher number.

       

      For example, when trying to find 12/7/2014-NJ-1, the process finds both that record
      and another record 12/7/2014-NJ-10.

       

      How can I reorganize this such that the find routine obtains only record #1 and excludes record
      #10?

       

      Thanks.