Format two fields in a Union Query as Currency

[alansidman]

I have a union query that joins two other queries. It works without exception. I would like to format two of the fields as currency. The underlying queries are formatted as currency. The two fields are the SumOfCashAmt

SELECT [Doubtful Sum Off Balance Entity Level].UEN,
 [Doubtful Sum Off Balance Entity Level].Name,
  [Doubtful-Sum On Balance Entity Level].SumOfCashAmt AS [ON Balance Sum],
  [Doubtful Sum Off Balance Entity Level].SumOfCashAmt AS [OFF Balance Sum],[Doubtful-Sum On Balance Entity Level].DefaultCategoryDesc AS [On Balance Desc],[Doubtful Sum Off Balance Entity Level].DefaultCategoryDesc AS [Off Balance Desc]
FROM [Doubtful Sum Off Balance Entity Level] LEFT JOIN [Doubtful-Sum On Balance Entity Level] ON [Doubtful Sum Off Balance Entity Level].UEN = [Doubtful-Sum On Balance Entity Level].UEN;

UNION
 SELECT [Doubtful-Sum On Balance Entity Level].UEN,
 [Doubtful-Sum On Balance Entity Level].Name,
  [Doubtful-Sum On Balance Entity Level].SumOfCashAmt,
 [Doubtful Sum Off Balance Entity Level].SumOfCashAmt,[Doubtful-Sum On Balance Entity Level].DefaultCategoryDesc, [Doubtful Sum Off Balance Entity Level].DefaultCategoryDesc
FROM [Doubtful-Sum On Balance Entity Level] LEFT JOIN [Doubtful Sum Off Balance Entity Level] ON [Doubtful-Sum On Balance Entity Level].UEN = [Doubtful Sum Off Balance Entity Level].UEN;

Your thoughts on this?

Alan

[alansidman]

Got it. Duh!
Format(table.fieldname,"Currency")

Alan