Displaying Data - Please help!

[Sally]

I have a table in which there ia a patients id , the
admission date and the diagnosis. In a year a patient can
have several admissions into hospital, so they appear
sever al times on table as follows:

patid date diagcode
xxxx 1/1/1 zzzzz
xxxx 2/2/1 zxxxx
xxxx 6/3/1 xxssx

but I need to view the data as follows:

Patid Diagcode1 diagcode2 diagcode3
xxxx zzzzz zxxxx xxssx

Does anybody Know how to do this..is it even possible in
access?
Please help!

 

[Guest]

You should be able to do it with a CrosstabQuer


----- Sally wrote: ----

I have a table in which there ia a patients id , the
admission date and the diagnosis. In a year a patient can
have several admissions into hospital, so they appear
sever al times on table as follows

patid date diagcod
xxxx 1/1/1 zzzz
xxxx 2/2/1 zxxx
xxxx 6/3/1 xxss

but I need to view the data as follows

Patid Diagcode1 diagcode2 diagcode
xxxx zzzzz zxxxx xxss

Does anybody Know how to do this..is it even possible in
access
Please help!

 

[Chris]

The only way a Crosstab query would cut it is:

patientID XXXX YYYYY ZZZZZ
100 True

 

[Chris]

Bah, hit send too soon.

The crosstab query would get you close, but not exactly
what you want...

let me do some quick coding, and I'll get a good answer
for you.


Chris