a quickie

[damie]

I have a field in a query which does not come directly from a table and so has no format. I want to give 1222.34 the format "1,222.34€" for example but don't know where I do this in queries. Can someone fill me in?

Thanks

 

[Ukraine82]

You want to change your Currency format to Euro? If so, whatever you field is from your table change the format to EURO.

hth,

Michael

 

[damie]

I'm not sure I've been understood....

I have a table with various columns, all in the format of euros. When I create a query in which, for example, I add two columnss together, the resulting field appears simply as a number and not in euros. Is there an area in queries where you can select the format just as you do with tables?

 

[ecniv]

in the sql query builder/statement:

format([table/query].[field],"#,##0.00E") as [nameofnewfield]

Where the E is change to euro symbol. Either that or use CCur function to change the resulting sum from your query in a similar way above.


Vince