RoundUp decimal places in mailmerge

  • Thread starter Thread starter Limbo
  • Start date Start date
L

Limbo

Guest
I have a mailmerge document merged from an Access Query containing a number of IIFs. How can I instruct the merge cell in my word document to round up to the next whole number eg, merge returns 1.04 or 1.54 and I want either example to return 2.00 not just 2 or 2.0 but 2.00; any help would be gratefully received. :confused:
 
What if you use Round function in your query or Format function

Round([YourFieldName],2) or
Format([YourFieldName],"##0.00")
 
Use of Roundup in Queries

Managed to solve the problem with the following:

-Int(-[MyValue])
;)
 

Users who are viewing this thread

Back
Top Bottom