Seperate Dollars and Cents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to thank fredg for helping me with thes subject earlier, but I need
further guidance. I need to do the same thing to the unbound text
(=Sum[grantT]. If i Substitute the above text for the FieldName that fredg
gave me I can't get it to work. can someone help me or have I not made myself
clear??
 
I wish to thank fredg for helping me with thes subject earlier, but I need
further guidance. I need to do the same thing to the unbound text
(=Sum[grantT]. If i Substitute the above text for the FieldName that fredg
gave me I can't get it to work. can someone help me or have I not made myself
clear??
Click to expand...

You haven't made yourself clear because you haven't included whatever
it was I suggested in an earlier post.
I certainly don't remember, and I don't think anyone else will either.

Why not repost and include whatever it was you asked before, as well
as my response, and then include this new question and what it is you
wish to accomplish.

By the way, your expression
(=Sum[grantT]
is incorrectly written.
 
fredg said:
I wish to thank fredg for helping me with thes subject earlier, but I need
further guidance. I need to do the same thing to the unbound text
(=Sum[grantT]. If i Substitute the above text for the FieldName that fredg
gave me I can't get it to work. can someone help me or have I not made myself
clear??
Click to expand...

You haven't made yourself clear because you haven't included whatever
it was I suggested in an earlier post.
I certainly don't remember, and I don't think anyone else will either.

Why not repost and include whatever it was you asked before, as well
as my response, and then include this new question and what it is you
wish to accomplish.

By the way, your expression
(=Sum[grantT]
is incorrectly written.
Click to expand...
My origional was as follows:I have a currency filed in a query. I want to seperate the Dollars from the Cents, as in writing a check. ie:the field is 250.25. I want to show 250 dollars and 25/100----.
Click to expand...

Your response:
In an unbound control:
=Int([FiledName]) & " dollars and " &
Format(CStr(([FieldName]-Int([FieldName]))*100),"00")&"/100"

The above worked fine and I thank you for it. I print out the "FieldName"
in the detail of the report and print out the total of those "FieldNames" in
the footer in the following manner: =Sum([FieldName]). When I substitute the
Sum expression in the formula above it doesnt work. What am I doing wrong?
The FieldName in the above "Sum" expression is a Calculation in the query
Field. ie: Grandt:[Total]-BeefCkOff]. Grant is the FieldName I used in your
formula above.
Thanks Fred.
Click to expand...

In which footer? The Page Footer?
You cannot do calculations like this in the page footer.

Place an unbound control in the detail section.

Set it's Control Source to:
=Sum([FieldName])
or..
Set it's control source to [FieldName]
Set the Running Sum property to Over All.

Name this control "TotalUp"
You can make it not visible if you wish.

In the PageFooter add an unbound control.
Set it's Control Source to:
=Int([TotalUp]) & " dollars and " &
Format(CStr(([TotalUp]-Int([TotalUp]))*100),"00")&"/100"

For more information, see:
See Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
 
Thank you fredg---it worked just fine!!!

fredg said:
fredg said:
On Tue, 14 Sep 2004 14:39:03 -0700, RAB wrote:

I wish to thank fredg for helping me with thes subject earlier, but I need
further guidance. I need to do the same thing to the unbound text
(=Sum[grantT]. If i Substitute the above text for the FieldName that fredg
gave me I can't get it to work. can someone help me or have I not made myself
clear??

You haven't made yourself clear because you haven't included whatever
it was I suggested in an earlier post.
I certainly don't remember, and I don't think anyone else will either.

Why not repost and include whatever it was you asked before, as well
as my response, and then include this new question and what it is you
wish to accomplish.

By the way, your expression
(=Sum[grantT]
is incorrectly written.
Click to expand...
My origional was as follows:I have a currency filed in a query. I want to seperate the Dollars from the Cents, as in writing a check. ie:the field is 250.25. I want to show 250 dollars and 25/100----.
Click to expand...

Your response:
In an unbound control:
=Int([FiledName]) & " dollars and " &
Format(CStr(([FieldName]-Int([FieldName]))*100),"00")&"/100"

The above worked fine and I thank you for it. I print out the "FieldName"
in the detail of the report and print out the total of those "FieldNames" in
the footer in the following manner: =Sum([FieldName]). When I substitute the
Sum expression in the formula above it doesnt work. What am I doing wrong?
The FieldName in the above "Sum" expression is a Calculation in the query
Field. ie: Grandt:[Total]-BeefCkOff]. Grant is the FieldName I used in your
formula above.
Thanks Fred.
Click to expand...

In which footer? The Page Footer?
You cannot do calculations like this in the page footer.

Place an unbound control in the detail section.

Set it's Control Source to:
=Sum([FieldName])
or..
Set it's control source to [FieldName]
Set the Running Sum property to Over All.

Name this control "TotalUp"
You can make it not visible if you wish.

In the PageFooter add an unbound control.
Set it's Control Source to:
=Int([TotalUp]) & " dollars and " &
Format(CStr(([TotalUp]-Int([TotalUp]))*100),"00")&"/100"

For more information, see:
See Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
Click to expand...
 
Back
Top