Formatting numbers in the qry design grid

[Andrew Thorpe]

In the query design grid I'm trying to concatenate a short piece of text with a currency field. It works, but unfortunately the currency then appears with lots of decimal places even though it appears everywhere else with the normal 2. I've tried setting it to 2 in the Properties formatting box, but that didn't work. Does anyone know an expression to force the formatting to remain at 2 decimal places. Thanks.

 

[MarkK]

What about something like...

SELECT txtField & Round(curField, 2) As NewField
FROM ...

 

[bob fitz]

Maybe:

SELECT "YourText  " & Format([YourField],"Currency") AS Result
FROM YourTable;

 

[Andrew Thorpe]

That's done it. Many thanks. Fantastic!!