How to Specify Data Type of Alias?

[Jerry Baker]

I have a query with an alias like this:

SELECT [Dollars] * 0.5 AS [Total]

The "Dollars" column is formatted as currency, but after this query
"Total" displays as integers. How do I make "Total" be a currency field
also?

Thanks.

 

[Van T. Dinh]

Try:

SELECT CCur([Dollars] * 0.5) AS [Total]