Thank you, June 7, for your link and explanation about percentages.
And pointing out to me the misuse of the word “percent” and showing us how to use a negative number with brackets.
Frida
Thank you, June 7, for your link and explanation about percentages.
And pointing out to me the misuse of the word “percent” and showing us how to use a negative number with brackets.
Frida
P. E. R. F. E. C. T, Armelgp!
Thank you for your assistance. We have now accomplished our goal.
Could you please suggest how to change the formatting of the negative values in the “Percentage Cost to Current Price field (18.70) to include negative brackets, as this is the format that my boss...
Thank you June7 for your information which is P.E.R.F.E.C.T. for our needs.
I could not reply earlier because we were having difficulty with our power supply.
Could you, please look at the updated database and advise us how to change the background colour of the field “$_Percentage”?
If the...
Thank you for your suggestion, Arnelgp.
I have tried your suggestion and as you can see in the attached screenshot, I cannot see any calculations.
Could you please advise me as to what I am doing wrong?
Could the problem be that I am using Access 2003?
We are trying to resolve all of our...
Thank you for your suggestion, Docman.
I have tried your suggestion and if you look at the attached screenshot, you will see that I cannot see any calculations.
Could you please advise me as to what I am doing wrong?
Frida
Thank you, TheDBguy, for your suggestion, which can change the colour of each field. However we are trying to find where the code is for the calculations in this form which was created in about 2010
Frida
If the "Stop Current $" and the "Percentage % Stop to Current Price" is "HIGHER" than the cost price, the Background would be Green,
If the "Stop Current $" and the "Percentage % Stop to Current Price" is "BELOW" the cost price the Background would be Red,
Your assistance will be appreciated...
Thank you ALL for your suggestions.
We have tried to FIX the problems with this form, which was created around 2010.
Instead, I will start from scratch and create a new for,, incorporating in your many suggestions.
THANK YOU
Barbara
Thank you ALL for your suggestions.
We have tried to FIX the problems with this form, which was created around 2010.
Instead, I will start from scratch and create a new for,, incorporating in your many suggestions.
THANK YOU
Barbara
Thank you ALL for your suggestions.
We have tried to FIX the problems with this form, which was created around 2010.
Instead, I will start from scratch and create a new for,, incorporating in your many suggestions.
THANK YOU
Barbara