Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge with Access 2002
I have an Access database that I am merging into a word document. My problem
is that my percentages do not want to merge correctly I enter in 5%, for example, as .05 into Access, but when it merges into word, it displays as 5.0000000000000003E-2. I have read previous posts, visited suggested websites, and read related articles, but have had no luck fixing my problem. I entered *100\#"0%" into the toggle field, and played around with other things as well, but the numbers displayed are not what I need. What do I do to get my 5% to display as 5%? Thanks for your help. |
#2
|
|||
|
|||
I entered *100\#"0%" into the toggle field
OK, *100#"0%" probably wouldn't be enough. You would at least need to use { ={ MERGEFIELD myfield }*100 } /#"0%" } where each pair of {} is entered using ctrl-F9 The other approach is to create a query in Access that does the conversion using vba functions (I don't have code to hand, but can probably work it out if necessary) and returns the result as a string. Then use that query as the data source. Peter Jamieson "Carolyn" wrote in message ... I have an Access database that I am merging into a word document. My problem is that my percentages do not want to merge correctly I enter in 5%, for example, as .05 into Access, but when it merges into word, it displays as 5.0000000000000003E-2. I have read previous posts, visited suggested websites, and read related articles, but have had no luck fixing my problem. I entered *100\#"0%" into the toggle field, and played around with other things as well, but the numbers displayed are not what I need. What do I do to get my 5% to display as 5%? Thanks for your help. |
#3
|
|||
|
|||
Thanks for the suggestions. I entered in {={MERGEFIELD my field}*100}/#"0%"}
but the result was always a syntax error. Finally, I came up with {={MERGEFIELD my field}*100\#"#%"}, and that worked for one field. I went to another field, and it came up as syntax error again. I don't understand why it would work for one field, and not another, but thats what is going on now. I think your idea of a query may be the thing to do. I am not very familiar with how to do that, but I will look it up in my book. If you have an other suggestions, I am all ears. Thank you so much for all of your help. "Peter Jamieson" wrote: I entered *100\#"0%" into the toggle field OK, *100#"0%" probably wouldn't be enough. You would at least need to use { ={ MERGEFIELD myfield }*100 } /#"0%" } where each pair of {} is entered using ctrl-F9 The other approach is to create a query in Access that does the conversion using vba functions (I don't have code to hand, but can probably work it out if necessary) and returns the result as a string. Then use that query as the data source. Peter Jamieson "Carolyn" wrote in message ... I have an Access database that I am merging into a word document. My problem is that my percentages do not want to merge correctly I enter in 5%, for example, as .05 into Access, but when it merges into word, it displays as 5.0000000000000003E-2. I have read previous posts, visited suggested websites, and read related articles, but have had no luck fixing my problem. I entered *100\#"0%" into the toggle field, and played around with other things as well, but the numbers displayed are not what I need. What do I do to get my 5% to display as 5%? Thanks for your help. |
#4
|
|||
|
|||
The answer is: {={ MERGEFIELD_"myfield"} *100\#"#%"}
where _= space between fields just for those of you who have had my problem. this will make your percent fields appear as percents from Access. "Carolyn" wrote: Thanks for the suggestions. I entered in {={MERGEFIELD my field}*100}/#"0%"} but the result was always a syntax error. Finally, I came up with {={MERGEFIELD my field}*100\#"#%"}, and that worked for one field. I went to another field, and it came up as syntax error again. I don't understand why it would work for one field, and not another, but thats what is going on now. I think your idea of a query may be the thing to do. I am not very familiar with how to do that, but I will look it up in my book. If you have an other suggestions, I am all ears. Thank you so much for all of your help. "Peter Jamieson" wrote: I entered *100\#"0%" into the toggle field OK, *100#"0%" probably wouldn't be enough. You would at least need to use { ={ MERGEFIELD myfield }*100 } /#"0%" } where each pair of {} is entered using ctrl-F9 The other approach is to create a query in Access that does the conversion using vba functions (I don't have code to hand, but can probably work it out if necessary) and returns the result as a string. Then use that query as the data source. Peter Jamieson "Carolyn" wrote in message ... I have an Access database that I am merging into a word document. My problem is that my percentages do not want to merge correctly I enter in 5%, for example, as .05 into Access, but when it merges into word, it displays as 5.0000000000000003E-2. I have read previous posts, visited suggested websites, and read related articles, but have had no luck fixing my problem. I entered *100\#"0%" into the toggle field, and played around with other things as well, but the numbers displayed are not what I need. What do I do to get my 5% to display as 5%? Thanks for your help. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automate a mail merge in Word 2002 from a macro in Access 2002 | Mailmerge | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
New problem - merge Word 2002 and Access 2002 par query | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
Word mail merge with Access | Mailmerge |