Select to view content in your preferred language

ArcPro - select by attributes returning all records when I type input into the expression

05-29-2023 05:58 AM
New Contributor

This is a new one for me. I’m trying to select by an annual mean wage by state. I’ve joined an excel table with a census feature layer and exported the joined layer to a .gdb, when I type input into the select by attributes table (for example, where annual mean wage is < or equal to my input), it returns all records. But when I use the numbers from the drop down that are actually within the field, it returns only the handful that I’m actually looking for. What am I doing wrong here?

0 Kudos
2 Replies
MVP Frequent Contributor

Would you be able to provide any screenshots? 

0 Kudos
Esri Contributor

Hi @lame153 

Is it possible that you have some extra spaces and the like in your table? I could see that being a circumstance where the dropdown is doing a better job of accurately selecting than when typing out your query. 

0 Kudos