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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting erros when exporting to another machine!!! 2
Currency Formatting Union Query 1
Undefined Function Format Error 1
Union Queries - Record Formatting 1
Sum between Dates 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Union query not displaying select statement 1
Date Limit in Crosstab from Union query 2

Back
Top