Excel formula to access query

Hi does any body no the access syntax to create this excel formula

=POWER(SQRT(L5/10)*47.1,2)/3769.9

Into access

Thanks

John

Create a query with this expression in it:

expr1: ((Sqr([anumber])*47.1)^2)/3769.9

IF you are taking the Square root of a number, multiplying it times 47.1, taking that value and raising it a power of 2, and then taking that entire value and dividing it by 3769.9


Hope this helps

Rickster57 said:

Create a query with this expression in it:

expr1: ((Sqr([anumber])*47.1)^2)/3769.9

IF you are taking the Square root of a number, multiplying it times 47.1, taking that value and raising it a power of 2, and then taking that entire value and dividing it by 3769.9


Hope this helps

Click to expand...

Maybe you guys can help me out. How can i mae^ke a query with this formula

=PRODUCT(1+O4:O42)^(12/COUNT(O4:O42))-1

I've tried this so far:

SELECT (Indices.DRS+1) As DRS FROM Indices; Which is working fine

Then I did SELECT 1^(count(Indices.DRS)/12) AS DRS FROM Indices and worked fine

But when i did it all SELECT (Indices.DRS+1)^(count(Indices.DRS)/12) As DRS FROM Indices; It didnt work BEcause I'm missing the product formula which i cannot find anywhere. Anyone know it?