Prev: IIf function help please
Next: Two Reports into one pdf file
From: Parish Pete on 17 Apr 2010 09:11
I'm trying to create a mail merge letter from a 2007 ACCB database using a
report (Word can't cope with the filter)

To keep the text flowing to allow for expansion of various field values,
I've put the following in a text box.

="According to my records you " & [Expr2] & " " & [KEYNO] & ", have made a
total payment of " & [PAID] & " comprising a permit fee of " & [PERMIT£] & "
and key deposit of " & [KEY£] & ". Therefore " & [Expr1]

Ignoring Expr1 & 2 which are text statements and [KEYNO] which is a 4 digit
integer The £0.00 values of [PAID], [PERMIT£] and [KEY£] simply won't
display as 2dp currency values even though the text box format is so set and
their query values are indeed currency.

I could break up the expression into a number of boxes so that it does work
but getting the letter layout right is a nightmare.

Any suggestions welcome

Pete

From: Peter Hibbs on 17 Apr 2010 09:33
Pete,

You could try formatting the currency fields like this :-

....payment of " & Format([PAID],"Currency") & " compr....

Peter Hibbs.


On Sat, 17 Apr 2010 06:11:01 -0700, Parish Pete
<ParishPete(a)discussions.microsoft.com> wrote:

>I'm trying to create a mail merge letter from a 2007 ACCB database using a
>report (Word can't cope with the filter)
>
>To keep the text flowing to allow for expansion of various field values,
>I've put the following in a text box.
>
>="According to my records you " & [Expr2] & " " & [KEYNO] & ", have made a
>total payment of " & [PAID] & " comprising a permit fee of " & [PERMIT�] & "
>and key deposit of " & [KEY�] & ". Therefore " & [Expr1]
>
>Ignoring Expr1 & 2 which are text statements and [KEYNO] which is a 4 digit
>integer The �0.00 values of [PAID], [PERMIT�] and [KEY�] simply won't
>display as 2dp currency values even though the text box format is so set and
>their query values are indeed currency.
>
>I could break up the expression into a number of boxes so that it does work
>but getting the letter layout right is a nightmare.
>
>Any suggestions welcome
>
>Pete
 | 
Pages: 1
Prev: IIf function help please
Next: Two Reports into one pdf file