list only most recent event in a query

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: lynn atkinson (anonymous_at_discussions.microsoft.com)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 03:30:48 -0700

I am trying to create a record of training courses
employees have been on.
Each course attended is recorded in the coursebookings
table.
I want to display a record of only the most recent courses
attended
ie if they attended a course in 2001, a refresher in 2002
and 2003, I just want the query to list the refresher in
2003. The course names are the same eg first aid, but each
time the course runs it has a unique id (event ID) which
is a course running on a particular date.

I have tried using the Max function on the query on the
date of the course, but it still lists the earlier
courses. Do I combine the max date with something else.
I cant get my head round this!

thanks

Relevant Pages

  • Re: list only most recent event in a query
    ... "lynn atkinson" wrote in message ... > ie if they attended a course in 2001, a refresher in 2002> and 2003, I just want the query to list the refresher in> 2003. ... > I have tried using the Max function on the query on the> date of the course, but it still lists the earlier> courses. ...
    (microsoft.public.access.queries)
  • Re: help with date query
    ... I just want to display the month ie Jan ... One column list numbers 1 to 12 and the other lists months Jan to Dec ... I set the criteria to point to the combo box. ... add a computed field Monthto the query ...
    (microsoft.public.access.gettingstarted)
  • Re: Not just returning value of selected record
    ... and a corresponding table that lists the serial numbers at each location. ... use an update query to add each serial ... that there is more than one position I want to display, ... not just the one for position1. ...
    (comp.databases.ms-access)
  • Re: Different behavior with list box and combo box
    ... You *could* populate the list/combo box with a query but, ... the list would display the same members for each record on ... then the lists would indeed be the same. ... Change the ", " in the function to vbCrLf, so that the focus areas are on ...
    (microsoft.public.access.formscoding)
  • Re: list only most recent event in a query
    ... Getting a related field from a GroupBy query ... Perth, Western Australia. ... > ie if they attended a course in 2001, a refresher in 2002 ... but it still lists the earlier ...
    (microsoft.public.access.queries)