stevnated
asked on
Query Builder in MS Access 2010 "improvement"
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, I know I can write the query that way, I just want to use the Builder. There's nothing wrong with the query itself ... If I use SCORE = 1 it works, because there's nothing in that stupid drop-down pop-up that starts with a 1. I can still use 2 also, but I have to hit [Escape]. I just want it back to how it was in 2003 where it doesn't try to guess what you are going to type. It's gotta be a configuration setting somewhere ...
"Sorry, but it's been a long standing "feature" "
Intellisense in query designer ?
Intellisense in query designer ?
ASKER
So the only way to do it is hit [Escape] after you type in your criteria?
<<"Sorry, but it's been a long standing "feature" "
Intellisense in query designer ? >>
After re-reading, I'm not it's the one I'm thinking of. The one I'm referring to is when your entering pure numbers. When you tab to the next field, Access adds one and populates the next field.
Drives me absolutly nuts and it's been around since A2 days.
Jim.
Intellisense in query designer ? >>
After re-reading, I'm not it's the one I'm thinking of. The one I'm referring to is when your entering pure numbers. When you tab to the next field, Access adds one and populates the next field.
Drives me absolutly nuts and it's been around since A2 days.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hey guys, ...
What am I missing?
<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>
I have never seen a Dropdown box in the criteria section of the QBE grid...?
Screenshots anyone?
Jeff
What am I missing?
<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>
I have never seen a Dropdown box in the criteria section of the QBE grid...?
Screenshots anyone?
Jeff
A2010 ... start typing some expression ...
mx
mx
ASKER
I guess the main problem is I have queries that start with numbers. So a simple query on a number pulls up my query instead. With text fields I just have to remember to add the quotes every time.
I've only been using 2010 (from 2003) for a couple of months and am still adapting to little things ...
I've only been using 2010 (from 2003) for a couple of months and am still adapting to little things ...
Yeah ... the 'little things'.
Welcome to our World :-)
mx
Welcome to our World :-)
mx
<A2010 ... start typing some expression ...>
?
Still not understanding...
?
Still not understanding...
Click Create - Query Design - A dialog appears to select source. Click Close
Click SQL
Type the following:
SELECT tbl.Score From tbl WHERE tbl.SCORE =2;
Switch to Design mode and check.