Calculations within 1 form

[warney316]

Hi folks i am relatively new to using Access Databases and have a query

i have created a form in Access which users manually input data into and i trying to work out if its possible that when data is entered into 2 fields called actual hours and hourly target (both long integers) then a calculation can be done and put into another field within the same form

The calculation would be actual hours/hourly target

Hope that makes sense

Thanks in advance

 

[CEH]

Just put an unbound textbox on your form. Insert the calculation as your textbox control source...... =[ActualHours]/[targetHours]

 

[hardhitter06]

How do you do it for a data access page?