Data Type In Calculated Field

[adams.bria]

Select query pulls in two fields from same table, both are currency type fields. Then I have a calculated field in the query finding the difference between the two, but the output is not currency. Is there some way to make the calculated field a currency data type?

 

[boblarson]

I think you just set the format property to Currency (don't have the ability to go in and look right now). You can also do that any other place you need it as well.

 

[MarkK]

SELECT CCur(Field1 + Field2) As Total FROM YourTable

Cheers,

 

[adams.bria]

Thanks LagBot... Didn't know it was that easy!

Tried setting the format property to currency still would not return in currency data type. Thanks for the quick reply though!

 

[boblarson]

Thanks LagBot... Didn't know it was that easy!

Tried setting the format property to currency still would not return in currency data type. Thanks for the quick reply though!

I was thinking you were talking about the actual CALCULATED FIELD datatype from Access 2010 and not A calculated field in a query. So, my answer would have been what you needed if that had been what you were asking about.