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.
 
| 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.
------------
Hi Karen,

We need more information. Which 10% of the employees will require an Xray
and which 90% won't?

Regards,
 
Back
Top