I have a table that has the following 3 fields
(type, shares and amount) as follows:
Type Shares Amount
---- ------ ------
values: C 10.00
C 20.00
S 800.00
S 900.00
-------------------------------------------------------
My goal is to create a report that shows the following:
The user wants to see these heading across the top of the page and the detail records running down the page.
Type Shares/Amount
--- -------------
C 10.00
C 20.00
S 800.00
S 900.00
Is there a way though SQL (or a Report feature) that I can create (in the query grid of a Report) 1 field named Shares/Amount that combines the values from the 2 separate table fields named Shares and Amount ?
(type, shares and amount) as follows:
Type Shares Amount
---- ------ ------
values: C 10.00
C 20.00
S 800.00
S 900.00
-------------------------------------------------------
My goal is to create a report that shows the following:
The user wants to see these heading across the top of the page and the detail records running down the page.
Type Shares/Amount
--- -------------
C 10.00
C 20.00
S 800.00
S 900.00
Is there a way though SQL (or a Report feature) that I can create (in the query grid of a Report) 1 field named Shares/Amount that combines the values from the 2 separate table fields named Shares and Amount ?