Results 1 to 3 of 3
  1. #1
    Sociotard is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Aug 2016
    Location
    Idaho Falls, ID
    Posts
    1

    Create a table of statistical results, not just a single total row

    I have a table with multiple tests, for moisture, protein, enzyme content, and so forth.



    Sample Moisture Protein
    1 10% 6.0
    2 12% 5.5
    3 11% 6.3


    I need to make a display of statistical information for each test type across all samples.

    Moisture Protein
    Max 13% 7.0
    Min 5% 3.0
    St Dev 2.5 1.0


    I don't know how to do this in Access! Totals kind of works, but it only makes one row, and Totals only appears at the end of an entire query, while I only want one nice little box to put in a report. This is easy in Excel, but Access is needed for other reasons.

    Do I need to do this in a form with each cell as a calculated value?

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Make table Recordsource for form. For each unbound box in the ControlSource, try functions

    =DMax("[Moisture]","YourTable")
    =DMin("[Moisture]","YourTable")
    =DSum("[Moisture]","YourTable")/DCount("[Moisture]","YourTable")

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make the result table above.
    build a macro. This macro will execute all the append queries to put the data in that result table.

    One query will do the MAX
    one will do the MIN
    etc

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

Similar Threads

  1. Replies: 14
    Last Post: 01-08-2016, 07:09 PM
  2. Replies: 3
    Last Post: 08-02-2015, 12:42 AM
  3. Replies: 9
    Last Post: 08-06-2012, 07:32 AM
  4. Replies: 3
    Last Post: 11-16-2011, 11:53 AM
  5. Create Multiple Charts from Single Table
    By Catch Wrestler in forum Reports
    Replies: 0
    Last Post: 06-17-2010, 08:33 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