Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Receiving calculations from an Access query and rounding off
I am calculating time spent in a program using various expressions to end up
with three numbers. These numbers I am able to round off (no decimal points) in Access using Fixed and zero decimal places, but when I merge it with Word, the complete number comes up, including 10 numbers to the right of the decimal point. I need Word to only express what is to the left of the decimal point, whole numbers. |
#2
|
|||
|
|||
See http://www.gmayor.com/formatting_word_fields.htm
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Robert Heinrich wrote: I am calculating time spent in a program using various expressions to end up with three numbers. These numbers I am able to round off (no decimal points) in Access using Fixed and zero decimal places, but when I merge it with Word, the complete number comes up, including 10 numbers to the right of the decimal point. I need Word to only express what is to the left of the decimal point, whole numbers. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2003 receives no records from Access 2003 query | Mailmerge | |||
Refreshing query with MS Access datasource | Microsoft Word Help | |||
How do I Mail Merge from an Access Query? | Mailmerge | |||
Merging from Access Query with one to many rocords | Microsoft Word Help | |||
mail merge and access query | Mailmerge |