Query formatted as currency - How?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with a query. I have the below sql statement, everything works
fine. However, I would like the 'Forecast' expression to be formatted as
Currency... Any suggestions?


SELECT ARBAL.Collector, Sum(ARBAL.[Cust AR Balance]) AS [SumOfCust AR
Balance], Sum([Cust AR Balance]*0.85) AS Forecast
FROM ARBAL
GROUP BY ARBAL.Collector
HAVING (((ARBAL.Collector)="7") AND ((Sum(ARBAL.[Cust AR Balance]))>10.89))
WITH OWNERACCESS OPTION;

Thanks :)
 
Is [Cust AR Balance] data type currency in the table? You can also in the
query design view right click on the column you want to change and select
properties and set the format to currency.
 
Schasteen,

The table does reflect currency for the field, however, in the query it
would not reflect the format. I did do a right click on the field in the
query and chose currency and it worked great.

Thanks for your quick response.
--
Gina


schasteen said:
Is [Cust AR Balance] data type currency in the table? You can also in the
query design view right click on the column you want to change and select
properties and set the format to currency.

Gina said:
I am working with a query. I have the below sql statement, everything works
fine. However, I would like the 'Forecast' expression to be formatted as
Currency... Any suggestions?


SELECT ARBAL.Collector, Sum(ARBAL.[Cust AR Balance]) AS [SumOfCust AR
Balance], Sum([Cust AR Balance]*0.85) AS Forecast
FROM ARBAL
GROUP BY ARBAL.Collector
HAVING (((ARBAL.Collector)="7") AND ((Sum(ARBAL.[Cust AR Balance]))>10.89))
WITH OWNERACCESS OPTION;

Thanks :)
Click to expand...
Click to expand...
 
Back
Top