Query Question

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

I have this query:
SELECT Employee.*, [Exam Schedule].PROGRAMS, [Exam
Schedule].EXAMLOC, [Exam Schedule].CLINIC
FROM Employee INNER JOIN [Exam Schedule] ON Employee.SSNO
= [Exam Schedule].SSNO;
The report is filterd by EXAMLOC. I have to pull all the
individuals from a exam location and then I then need to
take 10% of these individuals and have a label show up on
the report that they need a chest x-ray. All the other
employees outside of this 10% need to have a report that
does not say they need a chest x-ray.

The cxr information is stored in the Nurse table NDATE,
SSNO, CXR, etc.

Any help would be appreciated.
Click to expand...

karen
 
Probably one of the better solutions would be to create a
second query, which uses the one you listed as its data
source. If I'm guessing right, you have a field to
populate whether or not they need a chest x-ray or not.
If you do a select/update query, grouped by EXAMLOC, you
can then update that field by using the criteria of 1, 11,
21, etc get 'Chest X-Ray' and the rest get 'No X-ray'.

There are a number of ways to do this, and the decision
will have to be made based on the amount of data your
working with.

Hope this helps.
-----Original Message-----
I have this query:
SELECT Employee.*, [Exam Schedule].PROGRAMS, [Exam
Schedule].EXAMLOC, [Exam Schedule].CLINIC
FROM Employee INNER JOIN [Exam Schedule] ON Employee.SSNO
= [Exam Schedule].SSNO;
The report is filterd by EXAMLOC. I have to pull all the
individuals from a exam location and then I then need to
take 10% of these individuals and have a label show up on
the report that they need a chest x-ray. All the other
employees outside of this 10% need to have a report that
does not say they need a chest x-ray.

The cxr information is stored in the Nurse table NDATE,
SSNO, CXR, etc.

Any help would be appreciated.
Click to expand...

karen

.
Click to expand...
 
Back
Top