Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2021
    Posts
    1

    Adding Field column with Standard values (from another field column)

    Hello!

    Its a beginner question, and sorry for nerving.

    Lets say I have an already existing database with 6 fields: Mitarbeiter, Nachname, Vorname, Geschlecht, Geburtsdatum, AbteilungID.

    Now I would add a field called "New Field" and fill the cells with the first 4 letters of the Field "Nachname". (Like in the attached picture)

    How could I do that?



    Kind regards
    Attached Thumbnails Attached Thumbnails aaa.png  

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You wouldn't normally store that but calculate it in a query

    [NewField]: Left([NachName],4)

    This way it is always accurate if someone updates the Nachname field for any reason.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 03-16-2018, 08:26 AM
  2. Replies: 14
    Last Post: 07-13-2015, 12:47 PM
  3. Replies: 4
    Last Post: 05-15-2014, 11:20 AM
  4. Replies: 10
    Last Post: 05-22-2013, 02:56 PM
  5. Replies: 3
    Last Post: 09-28-2011, 04:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums