UnionQry $ not showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top