Hi
I have a consolidated file that needs to look at a radiology file and select whether it is an A, B or C tariff, D tariffs are to be ignored. However, the radiology file can not be sorted so the CRN numbers are random and I need to know whether there is anyway of selecting the first instance in Rad(1), second in Rad(2) and the third in Rad(3)................
Not sure how clear this is ... even I'm having problems in understanding it and I know what the problem is!!!!!!!!!!!!!!!!
Consolidated File
Rad(1) Rad(2) Rad(3)
A B
C
Radiology
CRN Date X-Ray
123456 01/04/2006 A
789789 05/04/2006 C
123456 08/04/2006 B
123456 20/04/20006 D
Many Thanks
KOLM#s
I have a consolidated file that needs to look at a radiology file and select whether it is an A, B or C tariff, D tariffs are to be ignored. However, the radiology file can not be sorted so the CRN numbers are random and I need to know whether there is anyway of selecting the first instance in Rad(1), second in Rad(2) and the third in Rad(3)................
Not sure how clear this is ... even I'm having problems in understanding it and I know what the problem is!!!!!!!!!!!!!!!!
Consolidated File
Rad(1) Rad(2) Rad(3)
A B
C
Radiology
CRN Date X-Ray
123456 01/04/2006 A
789789 05/04/2006 C
123456 08/04/2006 B
123456 20/04/20006 D
Many Thanks
KOLM#s