I have added a database to a word doc, which is working fine. It is 4 columns (3 text and 1 amount field). Problem is, the amount field will not display cents when they are zero's and it drops the decimal also. The display also drops zeros if the cents ends in zero. Since it is dynamic, there isn't anyway to format that column and I could not find any "display zero's" option setting. Any ideas?
Chuck
Extreme Programming = Plan -> Design -> Code -> Test