M
Mike375
Guest
You will look like Douglas MacArthur
Running Sum Query
- Thread starter access10000
- Start date
ajetrumpet
Banned
- Local time
- Today, 08:12
- Joined
- Jun 22, 2007
- Messages
- 5,638
Does he live in MacArthur Park?
(Actually, I think that's Maynard Ferguson..., or whoever the composer is of that song! I know it's not Ferguson)
(Actually, I think that's Maynard Ferguson..., or whoever the composer is of that song! I know it's not Ferguson)
M
Mike375
Guest
If the Access purists get hold of what you are doing you will be banned. No sideways
ajetrumpet
Banned
- Local time
- Today, 08:12
- Joined
- Jun 22, 2007
- Messages
- 5,638
Well, it IS against the structure rules of the program, so, if MS is as good as everyone says it's not, this should be possible. 
access10000
Registered User.
- Local time
- Today, 14:12
- Joined
- May 31, 2007
- Messages
- 25
Running Sum
Thanks. I'll have a look at it on a copy of 2000. I don't really see where it doesn't work though. I'm assuming you noticed the change in the grouping code? I just put it in to demo subgrouping.
If the the grouping code and order qtys are the same, and even if all values are the same apart from the Index - which would obviously always be different - it just carries on. I take it that's what you meant by when it hits a duplicate? The idea also works for running counts / running averages etc.
Anyway. Thanks for all the help and ideas. We all learn something off each other. That's what this site's here for eh?
Thanks. I'll have a look at it on a copy of 2000. I don't really see where it doesn't work though. I'm assuming you noticed the change in the grouping code? I just put it in to demo subgrouping.
If the the grouping code and order qtys are the same, and even if all values are the same apart from the Index - which would obviously always be different - it just carries on. I take it that's what you meant by when it hits a duplicate? The idea also works for running counts / running averages etc.
Anyway. Thanks for all the help and ideas. We all learn something off each other. That's what this site's here for eh?
ajetrumpet
Banned
- Local time
- Today, 08:12
- Joined
- Jun 22, 2007
- Messages
- 5,638
no elegance!
Mike,
Check out the sample. This is similar to what I had done last time. I printed the absolute positions of all the table's records in the table itself, and then opened a query from there. You need SOMETHING (anything really!!) to reference as a vertical identifier!!!! The SQL statement in the module is almost the exact same as I posted earlier, but I used the AbsPos property in the DSUM function in order to evaluate sequential, non-repeating numbers that served as identifiers. Doing this crap sideways, I could not figure it out. It's obviously not possible within the grid itself, but I am still convinced that it can be accomplished simply using functions. But, that's getting into the realm of either "crazy" or "not worth the time to figure out". The ideas I have though, for making something like that work are as follows:
1) Store the table's field values in an array with assigned element numbers, and check the values against the query's first column values using a function.
2) Use Static Variables (would this even work?). - I'm doubting this idea.
<Edit>
Try the following file instead MIKE. Now, it's customized a little bit, and everything works.
Do you think anyone would have any use for something like this? You can always add as many different "choice" variables as you want (like different tables, etc...). I have just got the choice listed as the field name.
Mike,
Check out the sample. This is similar to what I had done last time. I printed the absolute positions of all the table's records in the table itself, and then opened a query from there. You need SOMETHING (anything really!!) to reference as a vertical identifier!!!! The SQL statement in the module is almost the exact same as I posted earlier, but I used the AbsPos property in the DSUM function in order to evaluate sequential, non-repeating numbers that served as identifiers. Doing this crap sideways, I could not figure it out. It's obviously not possible within the grid itself, but I am still convinced that it can be accomplished simply using functions. But, that's getting into the realm of either "crazy" or "not worth the time to figure out".
The ideas I have though, for making something like that work are as follows:1) Store the table's field values in an array with assigned element numbers, and check the values against the query's first column values using a function.
2) Use Static Variables (would this even work?). - I'm doubting this idea.
<Edit>
Try the following file instead MIKE. Now, it's customized a little bit, and everything works.
Do you think anyone would have any use for something like this? You can always add as many different "choice" variables as you want (like different tables, etc...). I have just got the choice listed as the field name.
Last edited:
