Format of Output From A Query

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

carl

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.
 
yeah build a report queries dont/shouldn't work like that so just
create a new report
 
Back
Top