Help, I Don't Want To Hard Code!

[Sohaila Taravati]

Hi everybody,

I have about 28 fields that I have on a report. These fields are dollar amounts that the user puts in. On my report I want to show only 95% of the amount they input not the 100%. for example if the user puts in $405, in my report I want it to show $384.75 which is 95% of $405.

I know how to do this in a formula in the textbox or in the query, but is there a simpler way of just doing it once? I don't want to hard code it in the report. I was hoping if I can put something in the event procedure of the report or maybe put a flag or something in the table, incase, the 95% changes to another number. Because if they change this 95% to 80%, then I have to do this all over again for eacha of these reports. I hope I am making sense. Thank you in advace

 

[Sohaila Taravati]

Thank you for your reply Pat. I know that I needed to make another table out of my fields and did not normalize, but I had my reasons for doing this! These fields will not change at all or be added to. I run very complecated reports and by doing it like this my reports work perfectly. I figured yesterday to put a textbox on my report and made it =95%, and changed my other fields to multiply by the 95%, so all I have to do is everytime there is a change in the percentage, I just change the value in the text box and will change everything in the report for me. Unless there is an easier way of doing this. Thank you again