Results 1 to 3 of 3
  1. #1
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    comparing two sets of results

    My database collects school exam results and one form I use shows how many students got each grade for any particular exam. An example is shown below:
    Click image for larger version. 

Name:	forum1.png 
Views:	12 
Size:	9.4 KB 
ID:	40672

    Because of the large quantities of data, the process is currently:

    Extract all relevant data to a local table then display results in a form.

    However, my Line Manager would like to be able to compare two sets of data so I am thinking of having two tables similar to above set side by side. The user would be able to select both groups by combobox.

    Should I use subforms? Or can anyone see a wiser alternative?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    see this link for basically the same question https://www.accessforums.net/showthread.php?t=79383. Personally I would go the subform route

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Thanks Ajax. Looks like a subform then with two local tables.

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

Similar Threads

  1. Replies: 19
    Last Post: 09-25-2016, 05:37 AM
  2. Multiple sets of date
    By WhiskyLima in forum Reports
    Replies: 6
    Last Post: 06-24-2014, 03:30 AM
  3. Query using 2 sets of criteria
    By BRZ-Ryan in forum Queries
    Replies: 9
    Last Post: 12-27-2013, 09:05 AM
  4. Report with 2 sets of Dates
    By denileigh in forum Reports
    Replies: 1
    Last Post: 01-25-2012, 09:48 AM
  5. sets of queries
    By nashr1928 in forum Queries
    Replies: 2
    Last Post: 08-03-2010, 02:18 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