How to Specify Data Type of Alias?

  • Thread starter Thread starter Jerry Baker
  • Start date Start date
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.
 
Back
Top