Math Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
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...
 
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]
 
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])
 
Back
Top