Apr 20 2012, 01:40 PM
I use the FMS Emailer product and works fine except for one problem. I calculate a percent field CLKTHRURTE: ((Nz([2011 CONSOLID REF REGIST],0)+[2011 CONSOLID REF OTHER])/[2011 CONSOLID PAGE VIEWS])*100 For one example I get results of 6.0288 I have the table field of the percent format as #.## so percent is 6.03 which is correct. When I execute the emailer my results are 6.02883355176933. It doesn't seem to want to recognize the #.## format. My option currently is to create another field on the table that is "text" and rekey all the percents by hand just to get the emails out. Finally, my question. Is there a way (query) to take the percent field (numberic) and put the data into a text field that is in the format of X.XX? When I do key the text fld by hand. emailer sends out the correct percent. Thanks WV
Apr 20 2012, 01:52 PM
In a query, wrap that field in the Format function to look like you want it to. It will then be converted to text so make sure that isn't a problem.
As far as the formatting in the table, it's how the data is displayed and not necessarily how the data is stored. So any time you format a field in a table, don't be surprised if it looks differently elsewhere.