Displaying Data - Please help!

  • Thread starter Thread starter Sally
  • Start date Start date
S

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!
 
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!
 
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
 
Back
Top