Different formats in a concatenated field

G

Guest

Hi

I have a concatenated field with text and currency content - and am trying
to retain the currency formatting using the expression below... however an
error message keeps presenting saying "You may have entered an operand
without an operator"

Can anyone help me and advise me what I am doing wrong.

TIA


="Please find attached a receipt for your generous gift of" & " " &
Format([Amount]"Currency") & "."
 
G

Guest

Brilliant - thanks Allen - I picked the expression up from someone else's
post and obviously didn't read it closely enough.

Much Appreciated
--
Sue Compelling


Allen Browne said:
Needs a comma between the 2 arguments:

Format([Amount], "Currency")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Sue Compelling said:
Hi

I have a concatenated field with text and currency content - and am trying
to retain the currency formatting using the expression below... however an
error message keeps presenting saying "You may have entered an operand
without an operator"

Can anyone help me and advise me what I am doing wrong.

TIA


="Please find attached a receipt for your generous gift of" & " " &
Format([Amount]"Currency") & "."
Click to expand...
Click to expand...
 

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

Different formats in a concatenated field 2
Currency formatting lost in concatenated text string 4
Loop through a record set to change a currency field based on average difference of two fields 0
calculated currency field sorts like text instead of numeric 4
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Currency field in a report 2
Criteria not working on expression field in query 3
How do I find duplicates in a concatenated field? 16

Top