Query formatted as currency - How?

[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

 

[Guest]

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.

 

[Guest]

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

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.

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