Only show that later record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up two tables that have the following data.

1. Students
2. Class_Data

The class Data table has the classes that a student has taken. A student can
take the same class over time. A student may take Emergency Traffic Control
on 2 Jun 2001. This class Certification is good for two years. And then take
Emergency Traffic Control on 2 May 2003 again good for two years.

I would like to run the query and have it only show the LATER Emergency
Traffic Control on 2 Jun 2003 is do to be retaken.

Thanks

Keith
 
You should create a table of your classes with the following fields --
ClassID - autonumber - primary key
Name - text
Interval - number - interger - based on the number of months/years -
whatever is your lowest date interval - 2 for recurring every 2 years or 24
if you are using months. Use 0 (zero) if it is one time.

Use a totals query to pull the last time the class was taken and use
DateDiff in months/years to determine if the student is due.
 
Will give it a shot.

Thanks

KARL DEWEY said:
You should create a table of your classes with the following fields --
ClassID - autonumber - primary key
Name - text
Interval - number - interger - based on the number of months/years -
whatever is your lowest date interval - 2 for recurring every 2 years or 24
if you are using months. Use 0 (zero) if it is one time.

Use a totals query to pull the last time the class was taken and use
DateDiff in months/years to determine if the student is due.
Click to expand...
 
Back
Top