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

    Finding Records Using a Concatenated Text Field


      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