Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    11

    Unanswered: Concatenate Help

    Hi,

    I am sorry if this question has been asked before.

    I have set up a my concatenate to show the auto ref number and some text preceeding it - Ref No: "ILM-A" & " " & "/ " & "PQQ" & " " & [Ref]

    It all works fine except the Ref is only showing as 2 digits e.g ILM-A / PQQ 10 when I need it to show ILM-A / PQQ 0010. The Ref in the table is showing as four digits and I have played with the decimal places but just can't get it to do it.

    Any advice greatfully received.

    Janine

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    so apply a format to it
    myvar = "ILM-A" & " " & "/ " & "PQQ" & " " & format([Ref],"0000")
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •