played with rollup...no luck. so let me see if I can just get those values in asp and then i can do the math there.![]()
Thanks w00f w00f!
played with rollup...no luck. so let me see if I can just get those values in asp and then i can do the math there.![]()
Thanks w00f w00f!
Yes, after I looked at you data again, you are really wanting a Partial Rollup, which I don't think exists.
Wolffy
.-- ----- ..-. ..-. -.--
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
Thanks W0lffy,
Yea, I was just trying to make it easy when pulling into asp by having the results already in sql but for this don't think its gonna happen like that, so hopefully tomorrow I'll be able to see if some "If" statements do the trick in asp to get my value then easily do the math for the rest.
Wish me luck...i'm gonna need it.![]()
Bookmarks