Recent content by hankt

Even if Date had a time part, I have data from yesterday going back more than 4 years, I shouldn't worry about times in data should I? I state above that I tried changing the field name and had no luck. My hair is nearly gone anyway...

FYI, I changed the name of the Date column to Trade_Date and still have no records in the query results.

this query returns no records: SELECT Universe_v3.Date, Universe_v3.Ticker FROM Universe_v3 WHERE (((Universe_v3.Date) Between #5/30/2012# And Date())); Is it possible that the field name of Date is throwing a monkey wrench into the query? If I clear the criteria all records are returned.

The OCF and MV variables describe most of the value of your independent variable. R square is known as the coefficient of determination. Your second output with an R squared of 0.0139... shows that the remaining variables have effectively the same as zero influence on your independent variable...