Search results

After more thought I think I can get it to work with Jon's method. I think I need to create another subquery. Jon built a database called Previous Total where he accomplished something similar to what I want. I can not locate the thread but I have the database at home. I have been adapting his...

Refer to the timeline of events as to why I started a new thread. My second post was before John's answer. His post was a nice suprise providing a solution to a problem I had already solved. I ran into a new problem and hence the new post. Next time I will just keep the same thread going if that...

The last sentence of your post is exactly what I am trying to do. I just can not get it done. I had another post called "Another Previous Record Query" that has a sample database of what this is all about. Originally, I thought getting the daily percentages would be the hard part and then once I...

Thanks for the analysis. Very perceptive comments. You hit the core issue dead on when you said that an index is only a way to make things relative rather than absolute. Ultimately the Index performance will be used to calcluate the variance of the portfolio's returns. That way I can compare it...

Your solution is elegant and effective. My ego was soaring before I saw it because after weeks of struggle I figured out my own solution. I did not understand aliases but once I realized what they were I could do the self join with the counter trick. I had to reduce the query to running on...

I am calculating the performance of client portfolio accounts. I have a query that compares Day1 Port Value to Day0 portfolio value and calculates the percentage gain or loss. This was accomplished with a self-join and and ID field that counts up. For example Day1 = $11 and Day0 = $10 then the...

Hopefully it is attached this time.

Hello, Attached is a database with my problem. I have a table and two querys. Query1 does a simple sum and then Query2 should calculate a pct change. I need to compare the current value to the previous day's value and there's the rub. BegValue will always equal the previous day’s EndValue...