Results 1 to 2 of 2
  1. #1
    roberth is offline Novice
    Windows 2K Access 2007
    Join Date
    Dec 2014
    Posts
    2

    Analyze Data Fields Independently

    Hello everyone!

    I'm having an issue I believe is simple to resolve, but I cannot seem to figure it out. What I want to do is analyze the data from different fields independently. I guess the easiest way to explain it is that it's like a survey. I want to know the percentages, average, group etc. for different fields. Ie.

    Gender Happiness Favorite Color Education Age Range
    Male 2 Blue High school 25-30
    Female 8 Green Post Grad 35-40
    Male 9 Red None 10-15
    Female 8 Blue High school 35-40
    Male 7 Orange None 15-20
    Would generate a report such as:



    Gender
    Male: 60%
    Female: 40%

    Happiness
    Avg: 6.8

    Education:
    None: 2
    High school: 2
    Post Grad: 1

    Age Range:
    10-15: 1
    15-20: 1
    25-30: 1
    35-40: 2

    I know how to make a summary query for numeric fields, or group by to get the information above, but the problem is that there are many possible ways that I need to analyze (ie group by, average, count etc.) and I would need to run independent queries for each field which would be extremely slow. Is there anyway to make access (2007) look at the different fields independently? I am at a complete loss.

    Thank you!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Each different GROUP BY would mean a different query.

    An alternative might be Domain Aggregate expressions but they can be complicated and slow performers.

    Then there is VBA.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Analyze Access DB
    By Christian1977 in forum Access
    Replies: 2
    Last Post: 06-17-2013, 02:32 AM
  2. Can access analyze orders with a SKU list?
    By shubhamgandhi in forum Programming
    Replies: 3
    Last Post: 08-08-2011, 01:12 PM
  3. How to analyze holidays/weekends
    By Galio83 in forum Queries
    Replies: 0
    Last Post: 03-31-2011, 12:27 PM
  4. Replies: 3
    Last Post: 10-25-2010, 02:07 PM
  5. Replies: 1
    Last Post: 12-16-2009, 04:17 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