D
David Cleland
hi I posted about this a few weeks back but have no idea. I have a lookup
field on a form and I want to carry out a calculation based on the value of
another field multiplied by the value in the look up - but it is the value
of the second field.
eg the look up is item eg boat I can see the word boat and a second column
called cost. I want to carry out the calculation of the cost not the word if
that makes sense ?
David
field on a form and I want to carry out a calculation based on the value of
another field multiplied by the value in the look up - but it is the value
of the second field.
eg the look up is item eg boat I can see the word boat and a second column
called cost. I want to carry out the calculation of the cost not the word if
that makes sense ?
David