Format of Output From A Query

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

I am using this query:

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades;

Which generates output like this:

Total Volume: Total Trades: PIP Volume: PIP Trades:
608829 30415 68010 6023


The output is layed out in columns.

I am trying to have the output to look like this:


Total Volume: 608829
Total Trades: 30415
PIP Volume: 68010
PIP Trades: 6023

Where the output is in rows.

Is this possible ?

Thank you in advance.
 
This is a basic report format with the labels and text boxes stacked in the
detail section. Are you looking for something else?
 
Thank you Duane.

I have never created a report.

I tried using the Report Wizard.

I need to be able to Copy/Paste the data into a spreadsheet. For some reason
Access is not letting me copy the data from the report.



Duane Hookom said:
This is a basic report format with the labels and text boxes stacked in the
detail section. Are you looking for something else?

--
Duane Hookom
Microsoft Access MVP


carl said:
I am using this query:

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades;

Which generates output like this:

Total Volume: Total Trades: PIP Volume: PIP Trades:
608829 30415 68010 6023


The output is layed out in columns.

I am trying to have the output to look like this:


Total Volume: 608829
Total Trades: 30415
PIP Volume: 68010
PIP Trades: 6023

Where the output is in rows.

Is this possible ?

Thank you in advance.
Click to expand...
Click to expand...
 
I missed the part in your earlier message pertaining to copying and pasting
in Excel. Did you try export the report to Excel?

I would probably do all of this without a report involved. Are you exporting
only a single record? How often do you need to do this? You could copy and
paste from a query to Excel and then transpose the columns and rows.
--
Duane Hookom
Microsoft Access MVP


carl said:
Thank you Duane.

I have never created a report.

I tried using the Report Wizard.

I need to be able to Copy/Paste the data into a spreadsheet. For some reason
Access is not letting me copy the data from the report.



Duane Hookom said:
This is a basic report format with the labels and text boxes stacked in the
detail section. Are you looking for something else?

--
Duane Hookom
Microsoft Access MVP


carl said:
I am using this query:

SELECT TotalVolume.[Total Volume: ], TotalTrades.[Total Trades: ],
TotalPIPVolume.[PIP Volume: ], TotalPIPTrades.[PIP Trades: ]
FROM TotalVolume, TotalTrades, TotalPIPVolume, TotalPIPTrades;

Which generates output like this:

Total Volume: Total Trades: PIP Volume: PIP Trades:
608829 30415 68010 6023


The output is layed out in columns.

I am trying to have the output to look like this:


Total Volume: 608829
Total Trades: 30415
PIP Volume: 68010
PIP Trades: 6023

Where the output is in rows.

Is this possible ?

Thank you in advance.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top