adampierce <ap*******@gmail.comwrote:
>I think you hit it right on the head. I found a record that had some
corrupt data in it, and when I deleted it, the query worked! Thanks!
Thanks for posting back your solution. That message is exceedingly rare when I did
some searching at Google. I'd suggest purchasing some lottery tickets.
Added to the Access Corruption Symptoms page at my website.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -
http://msmvps.com/blogs/access/