Results 1 to 2 of 2
  1. #1
    aamer is offline Competent Performer
    Windows 7 Access 2007
    Join Date
    Jul 2010
    Location
    Pakistan
    Posts
    276

    Query Help

    How should I put the following in a query that the result in a field should be "Purchase Description" in first line then "XCCICode" in second line and "Salery Month" in the third line.




    Des: [Purchase Description] & " " & [XCCICode] & " " & [Salery Month]

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,530
    Personally I'd put them together in a form or report, but this type of thing:

    Expr1: [Purchase Description] & Chr(13) & Chr(10) & [XCCICode]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

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