Union Query Formatting

[Guest]

Hello all,

I have created a Union query to give me information from two tables and it
works well, except that the formatting of a numeric field which can refer to
any currency displays the default currency for everything! In the SQL
statement I formatted the field to display as Standard, but of course then it
becomes text! I tried writing a VAL function around it and the values were
displayed in thousands, eg insted of 14,235.50 I would get 14. Help....
I've just spent hours trawling through the questions and answers on the site,
but I haven't been able to find a solution. Can anyone help me please?

Thanks, Aehan

 

[Guest]

Try using your union query as source for a select query and fortmat it there.

 

[Guest]

Thanks Karl, I did think of doing that, but I thought there may be a way of
writing it into the SQL statement.