J
Julian Hustwitt
I am putting together an Access 2000 application for yacht
race scoring.
There are many formulae for calculating Corrected Time and
rather than hard code them all into the application
(pretty well impossible to identify them all) I want users
to be able to enter the formula they wish to utilise into
a field in a form.
I then want to take the formula from the form and place it
into the "Update To" field in an Update Query so that the
underlying Results table can be updated with the Corrected
Time according to whatever calculation formula the user is
using.
I have used the "Like" operator in the past to pull in
a "Criteria" value from a form into a Select Query but
that doesn't seem to work for the "Update To" value in an
Update Query.
Does anyone have any ideas on how to get arounf this
please?
race scoring.
There are many formulae for calculating Corrected Time and
rather than hard code them all into the application
(pretty well impossible to identify them all) I want users
to be able to enter the formula they wish to utilise into
a field in a form.
I then want to take the formula from the form and place it
into the "Update To" field in an Update Query so that the
underlying Results table can be updated with the Corrected
Time according to whatever calculation formula the user is
using.
I have used the "Like" operator in the past to pull in
a "Criteria" value from a form into a Select Query but
that doesn't seem to work for the "Update To" value in an
Update Query.
Does anyone have any ideas on how to get arounf this
please?