Excel formula to access query

  • Thread starter Thread starter pep1976
  • Start date Start date
P

pep1976

Guest
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

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?
 
Last edited:

Users who are viewing this thread

Back
Top Bottom