Forum Discussion
Re: Format as Euro in record source
Hi George,
Since its a Union query I dont think I can apply a format to the field as such since I dont think a Union query can be viewed in design mode. ? It does apply that format when I break out the separate queries making up the Union since design is visible in the separate queries. I copied and pasted the separate queries with the formatting shown above but there is no formatting since I dont think it carries over to the Union.
Maybe I am doing something wrong?
Since its a Union query I dont think I can apply a format to the field as such since I dont think a Union query can be viewed in design mode. ? It does apply that format when I break out the separate queries making up the Union since design is visible in the separate queries. I copied and pasted the separate queries with the formatting shown above but there is no formatting since I dont think it carries over to the Union.
Maybe I am doing something wrong?
6 Replies
My oversight. I missed that you have a Union Query.
You are right that the formatting isn't going to be available .
That leaves the ability to format the amount with the Euro sign, but not with the red font.
Format([AmountOriginEuros],"$#,##0.00") AS AmountOrigEAsD, Format([AmountOriginDollarsD],"€#,##0.00") AS AmountOrigDAsE
George, I get a data type mismatch if I use "€#,##0.00" as above. I thought that maybe its because of the format I have on [AmountOrig] at the table level but I dont think so?
- Oh, you used Double for the field size, not currency. I assumed since this is a Euro amount, you'd have defined it as Currency. I would have to check further to see if that makes any difference, though.
On the other hand, it often helps to include the actual SQL of the query in question to help spot issues.
