Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Two Texts Into One (A2000)

    I want to pull two texts into one text from a DLookup.
    The Dlookup works ok with one search:-

    =DLookUp("Client","tblPeriod","PeriodID = " & NZ([Forms]![frmCourtesyCarPlanner]![txtPeriod05],0))

    Can the below DLookup be edited for this purpose ?
    I've done this before with :- "=[Field1] & "," & [Field2]

    =DLookUp("Client" & "," & "Job","tblPeriod","PeriodID = " & NZ([Forms]![frmCourtesyCarPlanner]![txtPeriod05],0))

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Two Texts Into One (A2000)

    Dave, try

    =DLookUp("Client & ',' & Job","tblPeriod","PeriodID = " & NZ([Forms]![frmCourtesyCarPlanner]![txtPeriod05],0))

    Note that the comma is now surrounded by single quotes and that & ',' & is within the string that forms the first argument to DLookup.

Posting Permissions

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