It seems a "tolerance overflow" error has occurred here. A good error handler might post all the relevant information here, and suggest a "SLEEP" procedure (waking up after we have had a chance to consider that). I'm assuming the error occurs in "3) simple query" (else why would you have carried your description that far?) and that you have included parts 1) and 2) as background information? I see that you say you have checked the range of everything and my recollection of previous posts you have made in other groups suggest that you are much too advanced to say that numeric to numeric should work regardless of data type, unless there is something special that I don't understand. Can we assume that we are talking JET? Can we assume that your machinations with Date and Year do not at any time result in asking whatever engine we are using to put eight bytes of date information into a four byte integer holder? BTW, Aaron, when you are calm and rational, your capability shines through. When you rant, it's quite a bit harder to discern. It would be really helpful for me and probably for others as well, if you wrote a nice little post on Access and SharePoint, about which I know Zip. Yes, I could Google it, but some personal observations and pointers would provide a motivation for doing so.