In my tables I have some calculated fields which look like [WeeklySales]/60000
where [WeeklySales] is input via form. This calculated form returns a percentage.
There are also a couple of other areas which use this number, such as a query and a report, but 1 step at a time. The point is, these numbers might change from time to time (the 60000 part) and I am after a user friendly way of changing it in a calculated field in a table.
Is it possible to make a form where the user inputs the number and it updates a calculated field's formula?
where [WeeklySales] is input via form. This calculated form returns a percentage.
There are also a couple of other areas which use this number, such as a query and a report, but 1 step at a time. The point is, these numbers might change from time to time (the 60000 part) and I am after a user friendly way of changing it in a calculated field in a table.
Is it possible to make a form where the user inputs the number and it updates a calculated field's formula?