Different formats in a concatenated field

  • Thread starter Thread starter Guest
  • Start date Start date
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") & "."
 
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...
 
Back
Top