explaining total in the page footer

[liem khen]

after creating the page total ,I want to show the total
with texts in the page footer as well.
I can just show it in the report footer.
eg.:
in the page footer,if the "total"=$15 --> I want to show
it with texts fifteen dollars)

how to do it.

thanks a lot

 

[Marshall Barton]

after creating the page total ,I want to show the total
with texts in the page footer as well.
I can just show it in the report footer.
eg.:
in the page footer,if the "total"=$15 --> I want to show
it with texts fifteen dollars)

You can use this function to convert an amount to text:
http://www.mvps.org/access/modules/mdl0001.htm

 

[liem khen]

dear marshal,

I have used function as such,if I place it in the report
footer (and I do it),it is done.
neither do in the page footer.
will you help me how to show it in the page footer.

thanks

 

[Marshall Barton]

I have used function as such,if I place it in the report
footer (and I do it),it is done.
neither do in the page footer.
will you help me how to show it in the page footer.

The function will work anywhere, as long as you have a total
to convert. Are you saying that you can't calculate some
kind of total in the page footer?

What kind of total are you trying to display in the page
footer?
--
Marsh
MVP [MS Access]