Storing Expression in form

  • Thread starter Thread starter SJL
  • Start date Start date
S

SJL

Hi
I have three fields in a form CompetitorFare, Our Fare, Saving. The first
two are input manually with the second being the expression
=[CompetitorFare]-[OurFare]. How do I get this to store in the table this
form is attached to please so I can build query then report?

Thanks
 
Typically you don't save the calculated value. Do you have a good reason to
store it?
 
Hi

I want to have a "Total Savings" amount on the monthly report and thought it
would be easier to do this if the savings amount was saved. I have the
expression to get the same amount in report as Expr1, but cannot get this
column to total.



Duane Hookom said:
Typically you don't save the calculated value. Do you have a good reason to
store it?
--
Duane Hookom
Microsoft Access MVP


SJL said:
Hi
I have three fields in a form CompetitorFare, Our Fare, Saving. The first
two are input manually with the second being the expression
=[CompetitorFare]-[OurFare]. How do I get this to store in the table this
form is attached to please so I can build query then report?

Thanks
Click to expand...
Click to expand...
 
Figure out why it doesn't total. Are you trying to total in a Page Footer
rather than Group or Report footer? What are you trying to total? Are they
numeric?
--
Duane Hookom
Microsoft Access MVP


SJL said:
Hi

I want to have a "Total Savings" amount on the monthly report and thought it
would be easier to do this if the savings amount was saved. I have the
expression to get the same amount in report as Expr1, but cannot get this
column to total.



Duane Hookom said:
Typically you don't save the calculated value. Do you have a good reason to
store it?
--
Duane Hookom
Microsoft Access MVP


SJL said:
Hi
I have three fields in a form CompetitorFare, Our Fare, Saving. The first
two are input manually with the second being the expression
=[CompetitorFare]-[OurFare]. How do I get this to store in the table this
form is attached to please so I can build query then report?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Hi Duane

I am trying to total the savings (Expr1) Overall etc. I've done it in Report
footer, but it is showing the amount199.00 which would be incorrect. I wonder
if it because I am using the expression CompetitorFare - OurFare. In some
cases there is only "OurFare" present. That would mean that the Epr result,
though not showing on report would actually be a negative (-) number and this
may be where they 199.00 comes from. All fields are numeric.

Thanks

Duane Hookom said:
Figure out why it doesn't total. Are you trying to total in a Page Footer
rather than Group or Report footer? What are you trying to total? Are they
numeric?
--
Duane Hookom
Microsoft Access MVP


SJL said:
Hi

I want to have a "Total Savings" amount on the monthly report and thought it
would be easier to do this if the savings amount was saved. I have the
expression to get the same amount in report as Expr1, but cannot get this
column to total.



Duane Hookom said:
Typically you don't save the calculated value. Do you have a good reason to
store it?
--
Duane Hookom
Microsoft Access MVP


:

Hi
I have three fields in a form CompetitorFare, Our Fare, Saving. The first
two are input manually with the second being the expression
=[CompetitorFare]-[OurFare]. How do I get this to store in the table this
form is attached to please so I can build query then report?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
You need to define how you want to calculate if there is no CompetitorFare.
You might need something like:
=Sum(Nz([CompetitorFare],[OurFare])-[OurFare])
This would result in 0 difference if the CompetitorFare was Null.
--
Duane Hookom
Microsoft Access MVP


SJL said:
Hi Duane

I am trying to total the savings (Expr1) Overall etc. I've done it in Report
footer, but it is showing the amount199.00 which would be incorrect. I wonder
if it because I am using the expression CompetitorFare - OurFare. In some
cases there is only "OurFare" present. That would mean that the Epr result,
though not showing on report would actually be a negative (-) number and this
may be where they 199.00 comes from. All fields are numeric.

Thanks

Duane Hookom said:
Figure out why it doesn't total. Are you trying to total in a Page Footer
rather than Group or Report footer? What are you trying to total? Are they
numeric?
--
Duane Hookom
Microsoft Access MVP


SJL said:
Hi

I want to have a "Total Savings" amount on the monthly report and thought it
would be easier to do this if the savings amount was saved. I have the
expression to get the same amount in report as Expr1, but cannot get this
column to total.



:

Typically you don't save the calculated value. Do you have a good reason to
store it?
--
Duane Hookom
Microsoft Access MVP


:

Hi
I have three fields in a form CompetitorFare, Our Fare, Saving. The first
two are input manually with the second being the expression
=[CompetitorFare]-[OurFare]. How do I get this to store in the table this
form is attached to please so I can build query then report?

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top