I modified a query of mine but since then I can't run it because it gives me a "Too many fields defined" error. I have tried selecting Repair and Compact Database to get it to work but that has not. I'm not sure what else to do. The query has a ridiculous number of fields because it basically compiles all tables into one query, and then other queries run off of that for reporting (horribly inefficient, I know, but when I set it up I know virtually nothing about Access or how to set up a database). There are currently something like 120 fields, and when I added one more, it stopped working and gave that error. I am planning on redoing the database to make it easier to use and more efficient, but don't have time right now. I'm looking for a fix that I can use until I have time to redo this monstrosity. Anything that I can do that is fairly quick? Any help would be greatly appreciated!