2 Replies Latest reply on Feb 27, 2012 4:21 PM by AaronRoss

    Simple Field Question

    AaronRoss

      Title

      Simple Field Question

      Post

       Hello.

      I have two fields in my database that i need help with. The first field is called Rep Name. I need that field to auto generate the account user name for whoever is logged in. I figured out how to do that with managing the database.

      I also have another field called "initals" that requires the rep to put in their two letter initials. Is there a calculation that will take the first letter from the first and last name of the reps name from the Rep Name field?

        • 1. Re: Simple Field Question
          philmodjunk

          In many databases, separate fields are used for first and last name. In such cases, this could be your initials calculation:

          Left ( Firstname ; 1 ) & Left ( Lastname ; 1 )

          If you put both names in the same field, this can still be done, but then you have more variatations in format to deal with, such as the inclusion of middle names or initials.

          Left ( Leftwords ( namefield ; 1 ) ; 1 ) & Left ( Rightwords ( namefield ) ; 1 ) ; 1 )

          Might work, but you'll need to check it with real examples of the type and format of text you choose to permit with your databaes design.

          • 2. Re: Simple Field Question
            AaronRoss

             thnx phil ur a freakin wizard at this!