lookforsmt
Registered User.
- Local time
- Today, 12:19
- Joined
- Dec 26, 2011
- Messages
- 672
HI! in my db i am trying to summarize the output through cross-tab query.
The challenge i am facing is to give the field name a unique name to avoid multiple columns.
The field "RejectReason" has different reason names data
A) How do i get the below categorized as "Record No exists" so there is only one column and not 4 columns as below.
Record No [146] exists for the current Transaction
Record No [151] exists for the current Transaction
Record No [12167] exists for the current Transaction
Record No [146] exists for the current Transaction
And
B) The below categorized as "Record is not in Clear State"
Record[ 004221] is not in Clear State.
any help is much appreciated.
thanks
The challenge i am facing is to give the field name a unique name to avoid multiple columns.
The field "RejectReason" has different reason names data
A) How do i get the below categorized as "Record No exists" so there is only one column and not 4 columns as below.
Record No [146] exists for the current Transaction
Record No [151] exists for the current Transaction
Record No [12167] exists for the current Transaction
Record No [146] exists for the current Transaction
And
B) The below categorized as "Record is not in Clear State"
Record[ 004221] is not in Clear State.
any help is much appreciated.
thanks