Where? As a macro for each of the 8 Scientific format merge fileds or just
once?
"Doug Robbins - Word MVP" wrote:
No, you would put the expression in the mail merge main document.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"GCNY" wrote in message
news
Thank you for the response. I will try it.
In a QBE form do I set up an expression and enter this code after the
colon?
"Doug Robbins - Word MVP" wrote:
The following was posted by fellow MVP Macropod:
Quote
The following compound field will return the scientific notation of any
+ve
value between 10^-9 and 10^9:
{QUOTE
{SET a {SourceVal}}
{SET
b{=9-(a10^9)-(a10^8)-(a10^7)-(a10^6)-(a10^5)-(a10^4)-(a10^3)-(a10^2)
-(a10^1)-(a10^0)-(a10^-1)-(a10^-2)-(a10^-3)-(a10^-4)-(a10^-5)-(a10^-
6)-(a10^-7)-(a10^-8)}}
{SET c{=int(a/10^b)+mod(a,10^b)/10^b}}
{c \# 0.00}E{b \# +00;-00}}
where 'SourceVal' is the input, which could be a formula taking its input
from two formfields. You can extend the range easily enough by adding
more
terms.
All the field braces (i.e. { }) are created in pairs via Ctrl-F9. I've
laid
the coding out with line breaks to separate the key portions of the
coding,
but you don't really need them.
Unquote
I am not sure if this will work with mailmerge, but I think that the
thing
to do would be to replace
{SourceVal}
with your Merge Field that contains the value.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"GCNY" wrote in message
...
I have an Access 2003 database where some of the number fields are in
scientific format.
In Word 2003 when I insert the scientific formatted fields, they appear
in
decimal format.
How can I handle this formatting problem?