Hi,
I have data like this:
Pat_Number Code Result CRN Spec_Date
693947 HB 9999 976498 19/09/2003
693947 HB 9.7 976498 19/09/2003
693947 HB 8.8 976498 19/09/2003
693947 HB 8 976498 19/09/2003
693947 HB 16.4 976498 19/09/2003
693947 HB 8.5 976498 19/09/2003
and I want it to be like this:
Pat_Number Code Spec_Date CRN Result1 Result2 Result3...
693947 HB 19/09/2003 976498 8 8.5 8.8
(the 9999 result is a code for an error)
I can get a crosstab to give me as above but with the column titles as the result, i.e. 8|8.5|8.8 etc
How can I get the query to order and number the results?
Many thanks
Jim
I have data like this:
Pat_Number Code Result CRN Spec_Date
693947 HB 9999 976498 19/09/2003
693947 HB 9.7 976498 19/09/2003
693947 HB 8.8 976498 19/09/2003
693947 HB 8 976498 19/09/2003
693947 HB 16.4 976498 19/09/2003
693947 HB 8.5 976498 19/09/2003
and I want it to be like this:
Pat_Number Code Spec_Date CRN Result1 Result2 Result3...
693947 HB 19/09/2003 976498 8 8.5 8.8
(the 9999 result is a code for an error)
I can get a crosstab to give me as above but with the column titles as the result, i.e. 8|8.5|8.8 etc
How can I get the query to order and number the results?
Many thanks
Jim