Search results

  1. J

    Pi() function and update statement

    Hi all, Thanks all for the replies, and sorry I didn't reply anymore myself, I was a bit busy with other things. So I think I managed to add this pi() function but still I don't get the update statement running. Even if I try to run something like: update Update_test Set Volume=length*2; It...
  2. J

    Pi() function and update statement

    So that would mean I would have to write such a function in VBA? Or does anyone here has it already? Thanks, Brecht
  3. J

    Pi() function and update statement

    Dear all, I wanted to calculate the volume (of an egg) out of length and the width (measured) according to the following formula volume= (((1/6)* pi* Length* width^2)/1000) But I don’t get the Sql-script working. First of all this PI() function is not working, second it seems like...
Back
Top Bottom