Concatenated field dropping decimal places

[David Raven]

I have an Access report based on a query that contains the following field:

14day: "I request that full settlement of £" & [InvAmount] & " be forwarded
to us within the next 14 days."

InvAmount is set as a currency field, and has decimal places set to 2. If I
run the query the InvAmount field displays the whole number properly ie
£100.00, but in the concatenated 14day field, the .00 is dropped. If there
is a value ie £100.30, then the whole number is displayed.

Any pointers on how I can force the trailing zeroes to be displayed?


David Raven

 

[Nikos Yannacopoulos]

David,

There is no point in adding the text in a calculated field in a query. Let
the query return just the amount field InvAmount, and then add the text and
format the amount in the report, by setting the textbox's control source
property to:

= "I request that full settlement of £" & Format([InvAmount], "#,##0.00") &
" be forwarded to us within the next 14 days."

HTH,
Nikos

14day: "I request that full settlement of £" & [InvAmount] & " be forwarded

to us within the next 14 days."

I have an Access report based on a query that contains the following field:

14day: "I request that full settlement of £" & [InvAmount] & " be forwarded
to us within the next 14 days."

InvAmount is set as a currency field, and has decimal places set to 2. If I
run the query the InvAmount field displays the whole number properly ie
£100.00, but in the concatenated 14day field, the .00 is dropped. If there
is a value ie £100.30, then the whole number is displayed.

Any pointers on how I can force the trailing zeroes to be displayed?


David Raven