Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    i want to concatenate additional words (Access 2000)

    On my invoice i have a working concatenation showing the date and the city. It is the following:

    ="of: " & "" & [OrderDate] & " " & ' ' & "" & DLookUp("[mcfcity]";"My Company Information")

    It works fine. Unfortunately i have to add on the words "Point of Issue:" before the city.Our authorities require these words
    but it is a headache for me.I have tried many ways, one of them is the following:

    ="of: " & "" & [OrderDate] & " " & ' ' & " Point of issue" & "" & DLookUp("[mcfcity]";"My Company Information")

    but i am shown that it is entirely worng.
    Can somebody help me insert properly the words " Point of issue" in my working sentence?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: i want to concatenate additional words (Access 2000)

    For a start I believe that your expression could be just

    =

Posting Permissions

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