Results 1 to 3 of 3
  1. #1
    Corinne S is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2019
    Posts
    1

    Names Across Multiple Years

    I work for a non-profit charity and we need to track our donors, but we cannot afford expensive donor software. So we are trying to build our own database system.


    I have 5 Excel spreadsheets one for each year 2015-2019 which I imported into Access. Each sheet has the same headings Name, Contact Information and Year. Not every name is in every year and some years may have different names. What I need to do is make a query to find out which names are in which year. For example, the output might show:
    Mickey Mouse 2015, 2016, 2019
    Donald Duck 2015, 2018

    What is the best way to go about doing this? Any help is much appreciated.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    A common solution, presuming you've got all the data into one table with a year field:

    http://allenbrowne.com/func-concat.html
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    another solution would be to use a crosstab query

    row heading - group by name
    column heading - group by year
    value - first "X"

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

Similar Threads

  1. Replies: 8
    Last Post: 06-24-2015, 08:22 AM
  2. Replies: 2
    Last Post: 05-20-2014, 02:28 PM
  3. Design Question: Multiple years
    By dcfrancis in forum Database Design
    Replies: 4
    Last Post: 04-25-2012, 01:46 AM
  4. Replies: 5
    Last Post: 07-04-2011, 10:11 AM
  5. Query Multiple years
    By sammer021486 in forum Queries
    Replies: 3
    Last Post: 10-21-2009, 02:13 PM

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