Results 1 to 2 of 2
  1. 06-04-2013, 08:44 PM #1
    Moss
    Moss is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    1

    Exclamation Query - Not passing a module on time

    I am looking after the Professional Development database for all staff.

    Staff complete modules and if they fail they can retry. eg. see below. It shows that I eventually passed the module. If I hadn't passed the module by the due date how do I show this in my query. I have put in the Tests Status <>"Passed" but this does not show the modules not passed by the due date. Any help would be appreciated.

    Username Last Name, First Name N Date Contract Line Manager Status Division Business Unit Group Name Course Name Module Name Score Test Status Test Timing Date Attempted Due Date

    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 60 Failed Within Timeframe 9/07/2012 10/07/2012
    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 70 Failed Within Timeframe 9/07/2012 10/07/2012
    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 50 Failed Within Timeframe 9/07/2012 10/07/2012
    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 60 Failed Within Timeframe 9/07/2012 10/07/2012
    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 70 Failed Within Timeframe 9/07/2012 10/07/2012
    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 70 Failed Within Timeframe 9/07/2012 10/07/2012
    vamoss Moss, Vanessa Active QSuper Finance Fin Sys & Analysis & Procurement & Corporate Service RG1AWA RG146 Awareness 90 Passed Within Timeframe 9/07/2012 10/07/2012

    Reply With Quote Reply With Quote
  2. 06-05-2013, 12:43 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Not sure what you want. You have a field TestTiming that shows if completed within timeframe.

    Do you want query to show only the most recent attempt? Do you want query to list module with staff even if they have not made any attempt yet?
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How do I use a MODULE in a Cross-Tab Query?
    By timo1999 in forum Modules
    Replies: 2
    Last Post: 12-13-2014, 04:51 PM
  2. Query..Module..Macro....HELP!!!
    By RIRinkRat in forum Modules
    Replies: 1
    Last Post: 10-17-2012, 07:34 PM
  3. class module vs regular module
    By Madmax in forum Modules
    Replies: 1
    Last Post: 05-01-2012, 03:44 PM
  4. Run-time Errorless Bookmark/DLookUp Module Not Working
    By Soule in forum Modules
    Replies: 3
    Last Post: 02-03-2012, 06:37 PM
  5. Referencing and Changing A Form Module Variable From A Module
    By orcinus in forum Modules
    Replies: 4
    Last Post: 05-16-2011, 04:58 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums