Total in words

[Imranis]

is it possible that total in a report can be printed in words also, thanks.

 

[pcs]

you will need to use a function.
if you are wanting to do this for currency amounts,try here:

http://www.mvps.org/access/modules/mdl0001.htm

hth,
al

 

[varunmathur]

Hi,
I tried this some time back using this code to convert the sum total in a page footer into words. The problem I faced that was that It worked fine in the print preview of the report but failed to print of paper; There was a blank in the report where the total was supposed to be.
Has any one else faced this problem?
varun

 

[Imranis]

Thanks for reply, but still it isnot working. I have one field 'amount'. At Report footer section in an outbound filed of the report, i am using =Sum[amount], which gives me total in figures of all entries of 'amount'. I wish to convert this total in words. Can someone help, to give the full code, and how and where it should be written, i mean with which field of the report this should be attached.
Thanks.