Criteria in query is not working

[sshel55]

I am a pretty novice user overall and brand new to Access 2010. I am running a simple query against a table. In the criteria for a field, I specify a number, say 13. But when I run the query, it returns all numbers, not just those that are 13. I don't recall having this issue in Access 2007. What am I missing? If the field is designated to be a text field, rather than a number, would this affect what is returned by the query? How can I restrict my query to the data I want to see? PS. No coding answers please. I don't write code.

Thank you for your help.

[alansidman]

Post your SQL statement for analysis

[sshel55]

SELECT dbo_DONTRNS.DTTRYR, dbo_DONTRNS.DTTRMO, dbo_DONTRNS.DTTRDA, dbo_DONTRNS.DTDONR, dbo_DONTRNS.DTTRAN, dbo_DONTRNS.DTUNIT, dbo_DONTRNS.DTPROD
FROM dbo_DONTRNS
WHERE (((dbo_DONTRNS.DTTRYR)=13) AND ((dbo_DONTRNS.DTTRMO)=10) AND ((dbo_DONTRNS.DTTRAN)="010"));

Damn is now given. thanks.

[sshel55]

If I do a Make Table query, using these criteria it seems to work fine and filter the items I want to see. But when I just do a simple select query, it returns many records that don't match my criteria!?

[ssanfu]

Are fields "DTTRYR" and "DTTRMO" text type fields also?

[Dal Jeanis]

If DTTRYR is a text type field, put quotes around the value 13 => "13" and see what happens.

[sshel55]

Are fields "DTTRYR" and "DTTRMO" text type fields also?

No they are numeric fields. I had tried the " " and it didn't help. Any ideas why the make table query would work but the select query would not work? That's really odd to me.

[Dal Jeanis]

Steps -
1) Open a new query in design mode
2) switch to SQL mode
3) copy your code from post #3
4) paste that code to replace the SQL stub
5) Click the run button

Review to see if there are results where DTTRYR is not 13.

If so, do these steps:

6) Save the query as testqry1.
7) Create a new query. Paste the following as the code

SELECT DTTRYR FROM testqry1 
WHERE DTTRYR <> 13;

8) Run it. See if there are results.


My guess - you are seeing DTTRDA = 13, not DTTRYR = 13.