Different formats in a concatenated field

[Sue Compelling]

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") & "."

 

[Allen Browne]

Needs a comma between the 2 arguments:

Format([Amount], "Currency")

 

[Sue Compelling]

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

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.

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") & "."