How to calculate a square root in a query

G

Guest

Help! I am trying to make a query that calculates a new field based on the
square root of the value in an existing field. I have tried:

NewField: SQRT([OldField])

But I get the error "Undefined function 'SQRT' in expression"
Can anybody tell me what I am doing wrong?
 
G

Guest

Thank-you! that solves it!

(now, I wonder why wouldn't microsoft use the same functions in Access as
Excel???)

Brian Camire said:
Try:

NewField: Sqr([OldField])


frustrated said:
Help! I am trying to make a query that calculates a new field based on the
square root of the value in an existing field. I have tried:

NewField: SQRT([OldField])

But I get the error "Undefined function 'SQRT' in expression"
Can anybody tell me what I am doing wrong?
 
G

Guest

Especially as you look in Access help and it tells you it is SQRT for square
root.
--
Don


frustrated said:
Thank-you! that solves it!

(now, I wonder why wouldn't microsoft use the same functions in Access as
Excel???)

Brian Camire said:
Try:

NewField: Sqr([OldField])


frustrated said:
Help! I am trying to make a query that calculates a new field based on the
square root of the value in an existing field. I have tried:

NewField: SQRT([OldField])

But I get the error "Undefined function 'SQRT' in expression"
Can anybody tell me what I am doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top