Results 1 to 2 of 2
  1. #1
    cself is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Sep 2017
    Location
    Lousiana
    Posts
    5

    Combine columns or fields in a query

    How can combine two or three columns into one. I am not talking about addition. In this case, it is a list of categories in each column and the dollar amounts associated with that category. There should be an attachment to view.

    Thank you very much.
    Attached Thumbnails Attached Thumbnails Combine fields.jpg  

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Use concatenation. In the query add a column
    Code:
    What It Is: Designated1 & " / " & Designated2 & " / " & Designated3
    Field names should be letters and numbers (exception is the underscore) for object (field) names. (it appears that you have a "$" in a field name)


    There should be an attachment to view.
    Not sure what you mean by this.......

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

Similar Threads

  1. Replies: 3
    Last Post: 10-24-2017, 05:16 PM
  2. Replies: 5
    Last Post: 04-27-2017, 03:43 PM
  3. Replies: 7
    Last Post: 06-19-2014, 12:00 PM
  4. Query to find and COMBINE rows based on 2 fields
    By admessing in forum Queries
    Replies: 2
    Last Post: 12-13-2011, 12:59 PM
  5. Combine Two Fields in a Query?
    By Luke in forum Access
    Replies: 1
    Last Post: 07-28-2011, 10:00 AM

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