How to Specify Data Type of Alias?

J

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.
 
Top