Wording based on Report total

[rickyfong]

I am trying to create a report with customer information and related transactions. That is a master purchasing record with a few tranasction records per transaction. Just want to know how can I included some wordings in the ACCESS report which are based on the report sum total of the transactions showing in the report! e.g. $123 meant One hundred and twenty-three dollars only. Thanks a lot!!

 

[pbaldy]

Like this?

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

 

[rickyfong]

But my doubt is how can I post the result in the report?? Place a variable in the footnote?? In fact, I would to put the wording near the report sumtotal area!! Thanks!!

 

[pbaldy]

A textbox with a control source of:

=English(FieldName)