Format of Output From A Query

I posted yesterday and wnat to thank all who replied. For some reason I can't
reply to the postings.

If I use this query (Thank You Karl Dewey)

SELECT (count(TradeVolume)/2) AS Total_Volume, (sum(TradeVolume)/2) AS
Total_Trades
FROM HILLTOP;

Is there a way to get my outout to look like this:

Total_Volume:_Result of Query1
Total_Trades:_Result of Query2

I need the output to be layed out like above and I need the special
charactwer ":" as well as the spaces "_" as shown.

Thank you in advance.

Is there a way to get my outout to look like this:
I do not understand what you want. Total_Volume and Total_Trades will be
numbers, not text as you show.
--
KARL DEWEY
Build a little - Test a little


"carl" wrote:

I posted yesterday and wnat to thank all who replied. For some reason I can't
reply to the postings.

If I use this query (Thank You Karl Dewey)

SELECT (count(TradeVolume)/2) AS Total_Volume, (sum(TradeVolume)/2) AS
Total_Trades
FROM HILLTOP;

Is there a way to get my outout to look like this:

Total_Volume:_Result of Query1
Total_Trades:_Result of Query2

I need the output to be layed out like above and I need the special
charactwer ":" as well as the spaces "_" as shown.

Thank you in advance.

yeah build a report queries dont/shouldn't work like that so just
create a new report