Search results

I'm posting this here because I'd love to be able to automate an export to excel, where I can use multiple sheets to calculate returns, then import the new numbers back into access as a new table. Is there a way to tell Access to import from a sheet where the fields are made up of 1) The row...

I have a module that maxes out my database about 2/3 of the way through running it. I then have to compact and try and pick up where I left off. The total time is close to 5 hours. I thought if I broke up the module into different databases and then linked them back to one shell, I'd stop...

I've been trying for two years to find a fast way to calculate montly returns for a universe of financial figures. I start out at a set value, (say $10,000) calculate a return based on that month's price change, then paste that number into a table. For the next month, I take that new value...

First time poster, can't believe it took me this long to find the forum, already gained lots of knowledge in the 5 minute tour. I am designing a scatter graph. I have 10 data sets and want one point where the X & Y intersect and I want to have a label (or legand entry) for a third column...