Results 1 to 3 of 3
  1. #1
    purge11 is offline Novice
    Windows 10 Access 2003
    Join Date
    Nov 2018
    Posts
    2

    Date query showing duplicate

    Hello,




    I am trying to create a query showing the teachers who taught after a specific date, the problem is I want to show the teachercode field, but when I use it, it finds a teachercode before that date because a teachercode has been used before that date, how would I trap teachercodes e.g. after 2018? I hope my attachment makes more sense, but if it doesn't please let me know.

    Click image for larger version. 

Name:	Untitled-1.jpg 
Views:	12 
Size:	202.0 KB 
ID:	36170 Click image for larger version. 

Name:	Untitled-2.jpg 
Views:	12 
Size:	203.9 KB 
ID:	36171 Click image for larger version. 

Name:	Untitled-3.jpg 
Views:	12 
Size:	190.5 KB 
ID:	36172 Click image for larger version. 

Name:	Untitled-4.jpg 
Views:	12 
Size:	199.9 KB 
ID:	36173

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The criteria isn't on the date in the class table, it's on the exam table. What does it contain?

    Date isn't a good choice of field name. It can conflict with the built-in Date() function.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    purge11 is offline Novice
    Windows 10 Access 2003
    Join Date
    Nov 2018
    Posts
    2
    Hello Pbaldy,

    Thanks for getting back to me, here is what the class table contains.

    Click image for larger version. 

Name:	Untitled-5.jpg 
Views:	8 
Size:	155.0 KB 
ID:	36175

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

Similar Threads

  1. Access Query showing duplicate records
    By andrew.ang8843 in forum Queries
    Replies: 10
    Last Post: 12-08-2017, 02:23 AM
  2. Crosstab query showing duplicate rows
    By Aliasjeffturner in forum Queries
    Replies: 3
    Last Post: 04-18-2017, 07:10 AM
  3. Query Showing No Activity By Date Range
    By GWBMan in forum Queries
    Replies: 5
    Last Post: 08-16-2014, 09:51 AM
  4. query showing duplicate data
    By dan-gauci in forum Queries
    Replies: 2
    Last Post: 10-20-2011, 02:58 PM
  5. Date Range filter in a Duplicate query
    By knickolyed in forum Forms
    Replies: 0
    Last Post: 06-27-2011, 04:56 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