Search results for query: *

I have a column of dates and monthly percentages. To find the maximum drawdown I would (in excel) make another column of numbers which is the running total of percentages and then I would locate anywhere the running total goes down. The largest drawdown would be measured from running total...

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

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

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

My DB has monthly percentages. I want to compare sequential percentages and if they are negative multiple together to find max consecutive negative months. I can do this in multiple steps in excel, by doing an if statement and making all positive values =1 and then doing another column of ifs...

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

So I have a table where ladder_date is stored as Date/Time I then have the following query Select B.book_name,B.ladder_date,B.BOM,B.NAV,B.gMTDRT,B.gMTDPER,B.PreviousDay,Base, B.gTDRT,B.gTDCHANGEPER, (select ((Exp(SUM(Log(1+A.gTDCHANGEPER/100)))-1)*100) AS YTD from Daily_tt A where...

I have a table, with dates and corresponding percentages. I want to multiply all the percentages together that are in a particular time span. So if the span is short this could be multiplying two rows together, but it could be 100 of rows together. How can I do this?

I have one base table then I query from this table to make a record set I manipulate the data using some looping functions I then loop thru the array assigning it to a RS. Then I write this record set to a new table. What I want is have the write function to check if the data already exists...

I have a table, which I put in a recordset, and then to arrays because I more elaborate functions maniplate the the data. Now I have this array and I want to put it back into a table How? I want to cycle thru the array and assign to the table.

I want to multiple all column values together given they before given date. table A with values looks like date/ value and then there is a second table (B) with dates and values I want to multiple all values in table A with dates earlier than a date in Table B, times the value of that given...

Big picture: I want to get a year to date field for every day I have MTD for each month, so in Jan MTD and YTD are equal but from then on YTD= YTD of previous month times MTD So with that information I tried SELECT A.ladder_date, A.gMTDPER, (select B.gMTDPER from gMTDSummary B WHERE...

I have queries are the basis to update tables. When updating tables I want to insert values but not to overwrite any existing data. How can I make sure I update something while checking if anything is there already. And if so, it can't be written. example Table ladder_date/NAV 1-21-05/2154...

I am summarizing daily table into monthly and yearly tables the following query works within a given year: but if you multiple years it fails (i.e. it doesn't distinguish between Suggestions? SELECT A.ladder_date, A.BOM, A.NAV, A.gMTDRT, A.gMTDPER FROM dailySummary AS A INNER JOIN ( SELECT...

I have a DB with daily records. I want to summarize it, and make a new table with just monthly information. structure: date/values/values/values ... How do I get the values just for last entered day of a month (it won't always be the 31st)

I have a DB with a numerical value for a given date. I want to calculate the daily difference, i.e. if the value is 125 on March 20, and 150 on March 21. I want to calculate the difference (which is 25 in this example). And then I will create new table which has the 25 value as a new column...