Search results

I meant to say, Thank You . It worked.

Thank Very You

Hi, I am trying to select records from a record set based on a date. When the date, 01/01/2010, is hard coded in the select statement, it works. rst.LockType = adLockOptimistic rst.Open "select * from signals where signals.datedaily > #1/1/2010#", CurrentProject.Connection...

i don't have an answer for you. This is just the way I approached . I need to calculate the following: the date I bought the stock, the date I sold it length of time in the trade profit percentage gained trade drawndown (based on hightest equity and lowest equity If it can be done...

Hi, I am new to ACCESS and need help with this. I have a table named SIGNALS. It has 5000 records in it. I want to loop through this table. Do some calculations with the data and add a record to a table named EQUITY. I can't get the code to work after days of trying. Ready to give...

Thanks for responding, but I need to loop thru the SIGNALS table. This fields in this table are Date , Flag. Flag can be 0 or 1. I'll be using code to determine from and to dates and other date fields that then get loaded into the EQUITY table. The Tradecount field is just a transaction...

Hi, I'm new to ACCESS What I am trying to do is: I am looping the the table SIGNALS and would like to append data to the table EQUITY. The following code is just a shell. Just to prove the logic works. Well, it doesn't You help is appreciated. Public Sub trade() 'Set up the...

I am trying to insert rows into a table. The reccount is just a sequence number that is unique and will serve as a key. Since I posted this, I changed the sql string from: mysqlstring = "INSERT INTO Trades (tradeno) values (reccount ) " to: mysqlstring = "INSERT INTO Trades (tradeno)...

I am running ACCESS 2000. I have stripped this down to the bare bones to figure it out. I am stumped. i have a table named TRADES. It has 1 field in it which is also the primary key. When I run the code below, the DoCmd.RunSql displays a window prompting me to enter the value. I don't...