Converting to 2 Decimal Places

[Carly]

I would like to force a field to be 2 decimal places in the SQL view of a query as I am creating a UNION.

If is there anyway of doing this? I have tried CONVERT() & FORMAT() but I can't seem to get this to work.

Any help would be greatfully received.

Kind Regards

Carly

 

[Mile-O]

CSng(Format([Field], "0.00"))