Math Help

[Guest]

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

 

[Guest]

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

 

[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

 

[Guest]

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

Jay

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

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

 

[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

Where are X and N coming from??

John W. Vinson[MVP]

 

[Guest]

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])