Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have created the following SQL statements in Microsoft Query (11.5510.6408)
when trying to summarize data to include in an Excel Pivottable: SELECT log(1+.05*`Curr SP500, 94-04`.RTN52) FROM `C:\Documents and Settings\DPW\My Documents\ABV2\Curr SP500`\`Curr SP500, 94-04.csv` `Curr SP500, 94-04` WHERE (`Curr SP500, 94-04`.`DECILE RS52`=1) When I try to execute the query, I get an error "Invalid Procedure Call", which I am guessing is associated with the "log" function, since the error disappears when I remove that statement. Is "log" not supported in Query? Other possible error in the above SQL? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return the logarithm stats for a line of best fit | Excel Worksheet Functions | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) | |||
Logarithm equation in charts | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Logarithm scaling for charts | Charts and Charting in Excel |