Query showing only 1 record? Access 2010

Hello. I am trying my hand on Access to try to work 2 large sets of excel file. Since my system is just hanging up with my trying to move around 500,000 record file, I decided to see if Access could help me. Immediately, I am finding myself lost.

Just to try to understand something:

I have a 4-col table: CITY, STATE, ZIP, COUNTY

SQL query is:
SELECT [CB Data].City, [CB Data].State, [CB Data].zip, [CB Data].cty_name
FROM [CB Data]
WHERE ((([CB Data].State)="TX"));

In Design View: I enter just TX in criteria box for State.

When I run the query, I get one record back with TX under State. No values under CITY, ZIP and COUNTY. I can't make sense of it. There are over 2000+ records for State = TX.

If I can understand what's going on then I need to do this:

Table 1 has: CITY, STATE, ZIP
Table 2 has: CITY, STATE, ZIP, COUNTY_NAME

Join Table 1 to Table 2 on CITY, STATE, ZIP and pull COUNTY_NAME

Never had a need to use Access and now I need to start dabbling in it.

Appreciate your help in advance.

I have NEVER seen a query be case sensitive. It always ignores case.

Thank you for the reply. I will review in light of your questions. I hope to be back today.

I found an issue in the Excel file. The two data sets that I am comparing (Table1 against Table2 and trying to pick up a Table2 value for matching records) have issues. one or the other table has special characters as I just discovered a few minutes ago. I created a test bed of my own and excel multi-column index_&_match formula worked as expected but wouldn't work against the actual records. In absence of this knowledge, I had tried to use Access as a possible solution. I seem to have taken a positive step forward on my analysis. But I still want to use these tables as guinea pigs to exposing myself to Access.

So, the issue is not so much in Access, it seems. The SQL had seemed fine to me yesterday which was more confusing to me.

Once I can get my issue resolved in Excel then I can start again on Access.

Originally Posted by ranman256

I have NEVER seen a query be case sensitive. It always ignores case.

Also, one column had upper case city names but that data was "visible" as a result of the "UPPER" formula. I had read the file as is in the Access and was using that field in the Access query build up. That might have been another issue. I have to copy the column as "value" and remove the other column with the formula. So, when I bring the data back, once I have the issue resolved in Excel, all the columns (CITY, STATE) will be upper case as values (no formulas showing data).

Update: I did find a space in front of a data element. I trimmed it and was able to apply my formulas successfully in Excel. I will play with importing and doing the same in Access to start learning a bit in Access. I will do this next week. Hope all, for those in the USA, have a great Thanksgiving holiday!!!