explaining grand total in page footer

[liem khen]

mr. marshal barton,
I am really new to vba,so that I need the procedure to
show how to convert numeric to text in page footer.
I can just convert it in report footer!.
If you think there is a good book to read,tell me how to
find one.

once again thank you very much.

 

[Marshall Barton]

mr. marshal barton,
I am really new to vba,so that I need the procedure to
show how to convert numeric to text in page footer.
I can just convert it in report footer!.
If you think there is a good book to read,tell me how to
find one.

As I tried to explain before, your problem is not displaying
the numeric in text in the page footer. It's just a matter
of having a text box that uses the English function with the
total text box in its argument, no code beyond the function
is required.

Your problem is getting the numeric that you want to
convert. How you would get the numeric in the page footer
depends on how you are calculating the "total". If you'll
explain what the total is totaling, maybe someone will be
able to help you.

 

[liem khen]

mr. Marshal,
It was really a great help.
thank you veeeery much!