Reply
 
Thread Tools Display Modes
  #1   Report Post  
Robert Heinrich
 
Posts: n/a
Default 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   Report Post  
Graham Mayor
 
Posts: n/a
Default

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2003 receives no records from Access 2003 query Tor Michal Kinn Mailmerge 1 April 7th 05 11:26 AM
Refreshing query with MS Access datasource fishy Microsoft Word Help 1 February 10th 05 11:30 AM
How do I Mail Merge from an Access Query? geordymac Mailmerge 2 February 9th 05 07:59 AM
Merging from Access Query with one to many rocords Mohammad Saeb Microsoft Word Help 2 January 11th 05 02:21 PM
mail merge and access query DaveAS Mailmerge 6 January 6th 05 06:33 PM


All times are GMT +1. The time now is 11:20 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"