Percentage Change in Value (2 Viewers)

[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.