SQL 2000 - How to show the column records as seperate Columns
- From: "NewBee" <cutahir@xxxxxxxxx>
- Date: 29 Mar 2007 10:06:29 -0700
Hi,
I am new in the field and might be asking a dumb question, but please
I still need help.
I am running the Business Object 5.1.8, and using Freehand SQL with
Oracle 8.1 connecting.
I have four columns e;g
Patient_Name Account_No Birthdate Result Result
Value
Test One 123 1950
Pain 2
Test One 123 1950
Anxiety 5
Test TWO 234 1980 Nausea
1
TEST Three 456 1970 Anxiety
3
TEST Three 456 1970
Pain 4
I would like to have the results in the follow order:
Patient_Name Account_No Birthdate Pain Anxiety
Nausea
Test One 123 1950
2 5
Test TWO 234
1980 1
TEST Three 456 1970
4 3
Is there anybody who can help me.
.
- Follow-Ups:
- Prev by Date: Re: Log Out automatic in ACCESS
- Next by Date: Distributable Commercial Apps Access Vs Delphi
- Previous by thread: Re: Log Out automatic in ACCESS
- Next by thread: Re: SQL 2000 - How to show the column records as seperate Columns
- Index(es):
