Help with using function in Query

[georgedwilkinson]

Thank you so much-We finally got it working just perfectly. I cannot thank you enough for all of your time and patience. I sure did learn a lot! I hope other people did too!

I do have one glitch when we add this to the larger database. When we run the quartile function, it freezes, when we start it again, it has erased the code in the quartile function and only leaves the top two lines. We are testing but didn't know if this was a bug in access2000, or if this is conflicting with another module. Just thought I would throw it out there.


Thanks again for all of your help-I could have kissed you on your forehead Friday!!!!!

I'm glad you got it working.

The problem you're having doesn't ring a bell with me from a bug perspective...but percentile functions are slow. Just make sure you remove all breakpoints from your VBA before testing...that can cause some rather odd lockups. In your VB Editor, go to Debug|Clear All Breakpoints and then save your modules.

As far as the kiss...sounds intriguing, except if the gender's wrong...and I've got a wife who would mind...and, I'm a troll. Other than all that, sounds great.