All I want to do is a simple query on a constant. Say I have a table with a numeric column called "Score". I want to enter 2 in the Criteria Section. but it brings up a dropdown list of all the other tables and queries and operators and functions and god knows what else instead, and when I type 2 (Enter) my simple number 2 is now a query I have called [2011 Data]. I can't even type "is not null" without it wanting to insert something in the place of the word null!!!!! Surely this is a configurable setting? I can't find it though. Thanks for your help, I'm a little frustrated!