Search results

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...

Can anyone please help me out here. Thanks for all the help guys

Oh Ok Banana. Thanks a lot for the help. Maybe I should rename my fields then! About the JOIN im gonna use the INNER JOIN. Is that correct? Because it seems to me that The INNER JOIN operation can be used in any FROM clause to combine records from two tables. The thing is that i have only one...

anyone please???

Hey RuralGuy, well the data is fine. The thing is that to fill up the last row, which is number 40 i have to go through all the previous 39. So the idea was that all the 39 before were frozen Thanks

Hey Guys, Well i have a table with 39 observations. I made a form that updates the data of thid table. So the next values would be the observation number 40. What i wanted to do i that my form only showed the field that is not filled up, in this case would be the 40. Its like the form shows the...

Thanks a lot RV. QUESTION 1 For Q1 I did this: SELECT Indices.Month,IIf(Indices![SP 500 Index]>=0,1,0) AS BullDJWA FROM (SELECT Indices.Month,Abs(Bull_DJWA!BullDJWA-1) AS BearDJWA FROM Bull_DJWA) GROUP BY Indices.Month; And its asking me to enter parameter value for Indices![SP 500 Index]...

Hey guys, I'm a newby here. Im programing an Access as follows: I have 1 table called indices with the fields Month,DRS, 3-Month Treasury, Lehman Bros Agg Bd Index, Lehman Bros 1-3Y US Treas, Lehman Bros 7-10Y US Treas, Lehman Bros. 20+Y US Treas, JPMorgan EMBI+, SP 500 Index. Each filed has...