Search results for query: *

actually reading thru this what I really want is once in a drawdown start multipling the months together and find the max negative %, so the drawdown would be 0.8729721 which is just the percent changes of the last 4 together. In this case the numbers are similar but I was looking and when I...

...If CrtProd <> 1 Then If MinProd > CrtProd Then MinProd = CrtProd End If CrtProd = 1 Else CrtProd = CrtProd * rs!cc_rt End If rs.MoveNext Wend If CrtProd <> 1 Then If MinProd > CrtProd Then MinProd = CrtProd End If Debug.Print (MinProd - 1)...

ok, I am debugging this, but I am incorrectly setting the RS for the form NAV_bound I have Set Me.Recordset = rsNAV1 'Me.OpenArgs Dim strDate As String strDate = Me.OpenArgs Debug.Print strDate and the correct date (from Form3) is coming out...

where does the Me.OpenArgs go? I get an error when I put it with the set that it is invalid use of property Set Me.Recordset = rsNAV1 Me.OpenArgs 'then everything else I want to set

I have one form (Form3)which has the following code Private Sub ladder_date_DblClick(Cancel As Integer) DoCmd.OpenForm "NAV_bound", , , "ladder_date = " & [Forms]![FORM3]![ladder_date] End Sub where ladder_date is the date on the form. I then want it to open the form NAV_bound...

when i double click I am opening the form but the date has no effect it is just opening the new form at the beginning, is this because how the form is set up? so what I want: Form1 has a summary table in the form of a list. Then a second form NAV_bound, has details of that record. What I want...

I saw something like that, but I have a list box, which isn't a record set. Can/should I just change the data source to record set and make the record set the SQL query? When I look at the properties of a listbox I don't see any option which makes me believe it comes from a record set. How...

I have a form, which simply a list of dates and information from a query (which is simply a restatement of a table except for one criteria). I want to be able to click on given record and then another form opens up which has all the info in the table for that date. At the moment I have each...

that gives the same multi step error as listed above I inserting a variable to make it simplier, and still get the multi step operation error Dim temp As String temp = "Modified " & Now Me.comments = temp & Me.comments

rsNAV!notes is the record set and on the table the column is notes. by inserting the code suggested I get an run time error '-2147217887 (8004e21)' Multipe-step operation generated errors. Check each status value. So the base code, which works but doesn't do the automatic appending of the...

I have a field that I want to time stamp everytime there is a change. But I don't want to erase what was there. So I can't simply put Me.comment= date & time, I tried the below code but it breaks. How can I just append something witht the date and time? Private Sub cmdSaveAll_Click()...

the change did the job, I thought I tried that and it didn't work. but must have been something else. Thanks again.

...<> 1 Then If MinProd > CrtProd Then MinProd = CrtProd End If CrtProd = 1 Else CrtProd = -Abs(CrtProd * rs!percent) End If rs.MoveNext Wend If CrtProd <> 1 Then If MinProd > CrtProd Then MinProd = CrtProd End If Debug.Print MinProd End Sub...

...line above and and if less than one than multiples row with row above. example M1 -5% M2 1% M3 -4% M4 -6% M5 1% want this to return (.96*.94-1)*100 which is -9.76 or in another example M1 -10% M2 1% M3 -4% M4 -6% M5 1% this should just return -10 as that is the most...

I copied a table, just using copy paste, and renamed the old table tblPerformance_old and renamed the new one I copied just tblPerformance. I did this as I am testing some new data used for calculations. Anyway, when i run the vba code in excel which calls the table, I get an error box...

I am getting an error when I insert this code run-time error '1004' can't find qry_Performance2 WHERE tblPerformance.ladder_date<=#6/2/2006# note I have multiple versions of this query qry_Performance does not have a where clause and takes the whole database qry_Performance2 has the where...

I have an excel sheet, which I have pulling data from an access query. The query has many aggregrate functions. I want to prompt the user to enter a date, this is performance related data, and I want to choose an end date for the data. I do this in query by just adding the following clause to...

I am making a query up to a certain date, I want to then have that End date as a result in the query (note everything is aggregate functions, so all the other things are summing, multiplying to get single values from table) I just want the query to also return the date value as well as my...

the excel equivalent of what I want if(a<b,a-b,0) how can i have that in sql (access) I am use to oracle where I can use decode but that doesn't work in access

...B.gTDRT,B.gTDCHANGEPER, (select ((Exp(SUM(Log(1+A.gTDCHANGEPER/100)))-1)*100) AS YTD from Daily_tt A where B.ladder_date < A.ladder_date) from Daily_tt B; and it is returning an error, "Data type mismatch in criteria expression" but if I use an "=" it works, but I want the less than...