Percentage Change in Value

[access2010]

Hello.

Could we please receive assistance in fixing our Access 2003 form to show the Percentage change in values?

The formulas that we have tried do not work.

If the SHARE COST has NO VALUE a percentage is not required.

Thank you.

Crystal

 

[bob fitz]

Perhaps something like: =([Current_Price]-[Net_Share_Cost])/[Net_Share_Cost]
as the Record Source of the textbox called Percentage_PC

If you are intending to do anything else with this db I would suggest that you Normalize it and get rid of the many "Lookup" fields that you have.
Lookups should be on forms, not in tables.

 

[cheekybuddha]

as the Record Source of the textbox called Percentage_PC

Do you mean ControlSource rather than RecordSource?

 

[access2010]

Perhaps something like: =([Current_Price]-[Net_Share_Cost])/[Net_Share_Cost]
as the Record Source of the textbox called Percentage_PC

If you are intending to do anything else with this db I would suggest that you Normalize it and get rid of the many "Lookup" fields that you have.
Lookups should be on forms, not in tables.

Thank you Bob Fitz, P.E.R.F.E.C.T.
We know our databases need to be cleaned up as they go back to 1992. We are working on moving them all up to MsAccess 2010,

Nicole

 

[access2010]

Do you mean ControlSource rather than RecordSource?

Thank you CheekyBuddha for your question, and yes we do mean Record source.

Bob Fitz has kindly fixed our problem.

Nicole

 

[bob fitz]

Do you mean ControlSource rather than RecordSource?

Indeed. Thank you for the correction.

 

[access2010]

Perhaps something like: =([Current_Price]-[Net_Share_Cost])/[Net_Share_Cost]
as the Record Source of the textbox called Percentage_PC

If you are intending to do anything else with this db I would suggest that you Normalize it and get rid of the many "Lookup" fields that you have.
Lookups should be on forms, not in tables.

Thank you for your suggestion Bob on helping us obtain a percentage for the field “Net_Share_Cost”.
Using the same formula I have tried to get the percentage for another field “Percentage_PS” but the formula does not work.
Could you please advise me as to what I have done wrong?
Crystal

 

[bob fitz]

Thank you for your suggestion Bob on helping us obtain a percentage for the field “Net_Share_Cost”.
Using the same formula I have tried to get the percentage for another field “Percentage_PS” but the formula does not work.
Could you please advise me as to what I have done wrong?
Crystal

Perhaps: =([Current_Price]-[Stop_Current])/[stop_current]

 

[access2010]

Perhaps: =([Current_Price]-[Stop_Current])/[stop_current]

P.E.R.F.E.C.T. Thank you, this was the only combination that we did not try.
Nicole

 

[bob fitz]

P.E.R.F.E.C.T. Thank you, this was the only combination that we did not try.
Nicole

Your welcome. I suspect that it's all about understanding the maths