mail merge, how do I show decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Pulling mail merge info from a query in Access XP for currency. When a whole
number it does not shoe pence ie £50.00 displays as 50
 
I would just go into design view and find the desire field. Then I will go
into properties and change the format from there.

Hope this will help you!

MRZ
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On the whole, it is best to allow the value to be exported w/o the zero
decimal value, 'cuz the export of data is just a transfer function, and
50 = 50.00. When you display the data is when you will format it to
show the zero decimals. IOW, format the cell that holds the value to
show the value in monetary format.

If you really want to export zero decimals then you have to use the
Format() function on the value. That will change the value into a
string, which gets exported with the zero decimals. E.g.:

SELECT Format(Amount, "Currency") AS Amt, etc.

Or, w/o the monetary denomination symbol:

SELECT Format(Amount, "#.00") As Amt, etc.

You've got to be careful w/ Format() 'cuz it sometimes rounds values:

Format(999.9999, "#.00") -> 1000.00

but, if there are only 2 decimal places in the number this works OK:

Format(999.99, "#.00") -> 999.99

and this:

Format(9999.99, "Currency") -> £9,999.99

If you want to right-pad the number w/ zeros (12, in this case):

Format(9.99,String(12,"0") & ".00") -> 000000000009.99

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkR89IechKqOuFEgEQKgxACggeeq4TgFjukgX5Bz+qkJnpgk2x8An11N
5XAhUZIulz7MvH0syXDi0pGY
=cwf+
-----END PGP SIGNATURE-----
 
Back
Top