J
Jan
I am a new user and have created an access database solely for the purpose of
mailmerging letters to Word. I have created a Form for data input and have
created some calculated controls; when data is input all the figures are
correct. On testing the mailmerge the calculations field were blank. I now
realise that the calculation data is not updated in the table. I need these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are merged eg
£285,000 and correctly formatted in Access they have no formatting in Word ie
285000. Can anybody assist please it would be much appreciated. Thanks
mailmerging letters to Word. I have created a Form for data input and have
created some calculated controls; when data is input all the figures are
correct. On testing the mailmerge the calculations field were blank. I now
realise that the calculation data is not updated in the table. I need these
figures to be merged to Word and have no idea how I can do this?
Calculations are =[SALE PRICE]*COMMISSION] and =[FEE AMOUNT_minus_VAT]*0.15
and =[FEE AMOUNT_minus_VAT]+[VAT AMOUNT]. Also when the figures are merged eg
£285,000 and correctly formatted in Access they have no formatting in Word ie
285000. Can anybody assist please it would be much appreciated. Thanks