C
Chip
Hey Everyone,
Still working on the problem from last week. Your comments last week
were completely helpful. Thanks. I have modified my approach and
discovered the use of LAST operator in the query window.
To review, here is what I have. I have a list of students. Each
student needs to complete 4 practical examination stations. The
rsults of each station are Pass or Fail, no partial credit. The
default status is Not Tested Yet. What I want to do, is to have a
screen that is populated with a table, listing Student names and their
ID Numbers. and for each student, the current status of their Practicl
Exam station, along with a date of their Last attempt. Example,
ID Name AED AED Date BLS BLS Date Medical Medical
Date Trauma Trauma Date
1 Jones, John Pass 4/1/2004 Pass 4/1/2004 Fail
4/1/2004 Not Tested Yet
When a student goes into a station, the results of his attempt are
recorded in a table. I then have 4 queries set up, one for each
Station above. The query returns LAST date of the students attempt
and the result of that attempt. If the student has not attempted the
station, nothing is returned.
What I would like to do is have a master Form listing all the students
and 8 columns to the right of their name with each station and the
date of their last attempt. If the student has not attempted a
station yet, I would like the term "Not Tested Yet" to be displayed.
When I started the project, I intiially had 8 fields for each student
with the 8 fields noted above. I soon realized that this was not the
best approach, as this data was more apparopriately stored in sepaate
tables and queried as needed. So on my form, I'm expecting that the
data I woudl like to see, would be based on a query.
Is a Union query the way to go here?
chip
Still working on the problem from last week. Your comments last week
were completely helpful. Thanks. I have modified my approach and
discovered the use of LAST operator in the query window.
To review, here is what I have. I have a list of students. Each
student needs to complete 4 practical examination stations. The
rsults of each station are Pass or Fail, no partial credit. The
default status is Not Tested Yet. What I want to do, is to have a
screen that is populated with a table, listing Student names and their
ID Numbers. and for each student, the current status of their Practicl
Exam station, along with a date of their Last attempt. Example,
ID Name AED AED Date BLS BLS Date Medical Medical
Date Trauma Trauma Date
1 Jones, John Pass 4/1/2004 Pass 4/1/2004 Fail
4/1/2004 Not Tested Yet
When a student goes into a station, the results of his attempt are
recorded in a table. I then have 4 queries set up, one for each
Station above. The query returns LAST date of the students attempt
and the result of that attempt. If the student has not attempted the
station, nothing is returned.
What I would like to do is have a master Form listing all the students
and 8 columns to the right of their name with each station and the
date of their last attempt. If the student has not attempted a
station yet, I would like the term "Not Tested Yet" to be displayed.
When I started the project, I intiially had 8 fields for each student
with the 8 fields noted above. I soon realized that this was not the
best approach, as this data was more apparopriately stored in sepaate
tables and queried as needed. So on my form, I'm expecting that the
data I woudl like to see, would be based on a query.
Is a Union query the way to go here?
chip