Math Help

J

Jay

Hi (again) all,

Alright I'm horrible at math, and I've just managed to reconfirm that.
Hopefully someone can help me with this question. I think it's easy, but I'm
not seeing it.

I want to accomplish the following: x ^ (1/n)

Anyone know how to do that? This math stuff is killing me.

Any help is appreciated.

Thanks,
Jay
 
J

Jay

Again, I forgot valuable information...

The value will be the Control Source of a textbox. So I'm trying to use the
Built-In Functions from Access 97, not in VBA.

Jay
 
J

John Welch

I just tried typing
= 9^(1/2)
as a control source and it worked fine. If you want field names instead of
numbers, try:
= [field1]^(1/[field2])
make sure your fields are numerical, of course
hope this helps
-John
 
J

Jay

You're a genius! (Which makes me an idiot!) Thanks!

Jay

John Welch said:
I just tried typing
= 9^(1/2)
as a control source and it worked fine. If you want field names instead of
numbers, try:
= [field1]^(1/[field2])
make sure your fields are numerical, of course
hope this helps
-John

Jay said:
Hi (again) all,

Alright I'm horrible at math, and I've just managed to reconfirm that.
Hopefully someone can help me with this question. I think it's easy, but
I'm
not seeing it.

I want to accomplish the following: x ^ (1/n)

Anyone know how to do that? This math stuff is killing me.

Any help is appreciated.

Thanks,
Jay
Click to expand...
Click to expand...
 
J

John Vinson

Hi (again) all,

Alright I'm horrible at math, and I've just managed to reconfirm that.
Hopefully someone can help me with this question. I think it's easy, but I'm
not seeing it.

I want to accomplish the following: x ^ (1/n)

Anyone know how to do that? This math stuff is killing me.

Any help is appreciated.

Thanks,
Jay
Click to expand...

Where are X and N coming from??

John W. Vinson[MVP]
 
J

Jay

x -> the product of a column
n -> number of records

the final result has control source looking like this:
=Exp(Sum(Log(IIf([Yield] Is
Null,1,[Yield]))))^(1/[Form].[RecordsetClone].[RecordCount])
 
Top