Results 1 to 3 of 3
  1. #1
    Snickren is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    24

    Able to build a query off multple columns and condense it into one column?

    Doc2.zip
    Is it possible to take a query with multiple columns and condense the information down to one column? See attached. All of the information is the same I just divided it out for the form/entering purposes.Entering Form.zip


    Thank you!

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    if I've understood you correctly, your table is not designed properly and you want to redesign it with just the following columns

    firstname
    lastname
    living/deceased (they have to be one or the other)
    treelocation
    etc

    and this will be populated with up to 10 rows per something (not sure what)

    is this correct?

  3. #3
    Snickren is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    24
    Yes, that is correct. I built the table and it works well with the entering form but not when it comes to running a report. So I either need to figure out how I to do a form to enter multiple names every year and redesign the table. When I did redesign the table it messed with my other event information because some of the Donors have multiple names and tree locations so it only linked those donors and wouldn't allow me to search by any other names in the donor table.

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

Similar Threads

  1. Report with 4 columns (1 query per column)
    By Telejazzer in forum Reports
    Replies: 3
    Last Post: 06-12-2015, 12:24 PM
  2. Replies: 1
    Last Post: 12-08-2014, 06:16 PM
  3. Replies: 1
    Last Post: 12-20-2012, 11:03 AM
  4. Replies: 8
    Last Post: 10-22-2012, 07:43 PM
  5. How to build a datetime column ....
    By kkrishna in forum Access
    Replies: 3
    Last Post: 01-27-2011, 10:43 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