I apologize, I should have made this clearer earlier probably. In query analyzer I get the same erroneous results. The problem seems to lie in the sql.

Please post the EXACT code you are running in QA

Well, I was asked to change what date I was using. I went from using the date that was given when the entry was entered to using a hardcoded date field. That solved my problem. Apparently for some reason the auto date wasn't liked. I would love to continue to figure this problem out, but I currently have too much on my plate. Thank you so much for all of your help.

Well, anytime you want to get back to it, just let me know. I would be glad to help you more.

Jim