Access Forms with formulas

[Guest_imported]

I am trying to pull off of another field called Time. Where I have enter time someone has put on a project. Then I have another field called "% of time". In this field I want to calculate the time field then take it and have 12/40 * 100. To get the percentage. How do I do this in the Form of the properties of which field.

 

[jdegeorge]

Add an unbound text box to your form. Set the default value of that field to something like

=[TIME]*(12/40)*100

or whatever your calculation is.

You can do this in an unbound text box on a report as well.

Great part about doing this is that you don't have to store the value anywhere...it's only generated when needed on the form or report.

Hope this helps.

Jim "Get it right the first time, that's the main thing..."