Convert a formula

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

Guest

I have many formulas in a report, because of a percentage formula, I am
unable to get the correct total in the report footer. Is there a way to
convert a formula so that Access sees it as a number. For example
=[InvoiceAmount]*[Percentage]shows $25.00 on the report, how can I make
Access see the actual $25.00 so that I can do a total at the bottom?
Thanks
Jeannie
 
Try wrap your expression in Val().
=Val([InvoiceAmount]*[Percentage])
or
=[InvoiceAmount]*Val([Percentage])
 
Thanks for your answer
However, even though I still get the right answer ($25) for the control box,
the sum in the report footer still gives me $0. I thought maybe I could use
the format$ command to force Access to give me a number rather than a
formula, but I'm not quite sure how to use it
Thanks again
Jeannie

Duane Hookom said:
Try wrap your expression in Val().
=Val([InvoiceAmount]*[Percentage])
or
=[InvoiceAmount]*Val([Percentage])

--
Duane Hookom
MS Access MVP


Jeannie said:
I have many formulas in a report, because of a percentage formula, I am
unable to get the correct total in the report footer. Is there a way to
convert a formula so that Access sees it as a number. For example
=[InvoiceAmount]*[Percentage]shows $25.00 on the report, how can I make
Access see the actual $25.00 so that I can do a total at the bottom?
Thanks
Jeannie
Click to expand...
Click to expand...
 
I think you might need to use:
=Sum([InvoiceAmount]*[Percentage])
If this isn't correct, then I am having trouble understanding your question.

--
Duane Hookom
MS Access MVP
--

Jeannie said:
Thanks for your answer
However, even though I still get the right answer ($25) for the control
box,
the sum in the report footer still gives me $0. I thought maybe I could
use
the format$ command to force Access to give me a number rather than a
formula, but I'm not quite sure how to use it
Thanks again
Jeannie

Duane Hookom said:
Try wrap your expression in Val().
=Val([InvoiceAmount]*[Percentage])
or
=[InvoiceAmount]*Val([Percentage])

--
Duane Hookom
MS Access MVP


Jeannie said:
I have many formulas in a report, because of a percentage formula, I am
unable to get the correct total in the report footer. Is there a way
to
convert a formula so that Access sees it as a number. For example
=[InvoiceAmount]*[Percentage]shows $25.00 on the report, how can I make
Access see the actual $25.00 so that I can do a total at the bottom?
Thanks
Jeannie
Click to expand...
Click to expand...
Click to expand...
 
You were absolutely right, I put the Val command in my control box and then
got the total with the =sum command you just gave me (which was my original
one that I never put back after I change the to val) and it works perfectly.
Thank you so very much, I can finally stop staring blankely at this database.
Jeannie

Duane Hookom said:
I think you might need to use:
=Sum([InvoiceAmount]*[Percentage])
If this isn't correct, then I am having trouble understanding your question.

--
Duane Hookom
MS Access MVP
--

Jeannie said:
Thanks for your answer
However, even though I still get the right answer ($25) for the control
box,
the sum in the report footer still gives me $0. I thought maybe I could
use
the format$ command to force Access to give me a number rather than a
formula, but I'm not quite sure how to use it
Thanks again
Jeannie

Duane Hookom said:
Try wrap your expression in Val().
=Val([InvoiceAmount]*[Percentage])
or
=[InvoiceAmount]*Val([Percentage])

--
Duane Hookom
MS Access MVP


I have many formulas in a report, because of a percentage formula, I am
unable to get the correct total in the report footer. Is there a way
to
convert a formula so that Access sees it as a number. For example
=[InvoiceAmount]*[Percentage]shows $25.00 on the report, how can I make
Access see the actual $25.00 so that I can do a total at the bottom?
Thanks
Jeannie
Click to expand...
Click to expand...
Click to expand...
 
Back
Top