UnionQry $ not showing

D

DD

I have a UnionQry that is run from StatementsI and StatementP
the Due and Paid colunms are currency and show the
however when i union the two the currency format has gone
Any help pleas
SELECT * FROM qryStatement
UNION SELECT * FROM qryStatement
ORDER BY thedate
 
J

John Spencer (MVP)

Then you will probably need to specify the fields and apply a format function to
the fields. On the other hand, if you are using the query results in a form or
report, you can use the format property of the controls to apply the desired format.
 
Top