Results 1 to 3 of 3
  1. #1
    Pickboy is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    5

    Question Add prefix to a formula

    Hi, I am new to Access and I think what I want to do is pretty simple but can't figure out how to do it

    I want to set a "Default Value" to a form "Text Box" to ( "SE" + a DCount value ) ... so the number will look like "SE1234".

    For now i've set my formula in the default value to " =DMax("[ID]","Inventory")+1 " but I cant figue how to add the "SE" prefix.

    Thanks for your help !

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,412
    I don't use macros much but would this work?
    = "SE" & DMax("[ID]","Inventory")+1

  3. #3
    Pickboy is offline Novice
    Windows 10 Access 2016
    Join Date
    Aug 2018
    Posts
    5
    Yes perfect ! Thanks a lot !

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

Similar Threads

  1. Prefix transfer to Union Query
    By Perfac in forum Queries
    Replies: 4
    Last Post: 06-19-2018, 01:21 PM
  2. use update query to add prefix to a field
    By djlabreche in forum Queries
    Replies: 3
    Last Post: 06-16-2014, 12:46 PM
  3. Prefix character in ID field
    By Zbeibu in forum Access
    Replies: 2
    Last Post: 05-14-2012, 07:21 AM
  4. Table naming - use prefix or not?
    By revnice in forum Access
    Replies: 4
    Last Post: 08-08-2010, 11:55 AM
  5. Add prefix to AutoNumber
    By sirmilt in forum Database Design
    Replies: 3
    Last Post: 07-09-2010, 01:41 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