Help - Need Help with Criteria

[Chris2122000]

I am importing txt files as my data to access. I am trying to create a
criteria of ">1 and <50" to filter out some data. When I import it as a text
it gives me data that is incosistent with my directions ie. It will give me
data from 60 to 100 but should be reflecting data only from 1 to 50. If I
convert it to a number. It will not work and says the data does not match.
Please help me solve this.

I am new at access so any info would be greatly appreciated!~!

 

[Ray_Rattler]

Your quotes are incorrect. It would be more appropriate to just type in >1
and <50 and let Access add the quotes for you. This criteria won't work if
you are using the field as a text field.

Hope this helps

 

[KARL DEWEY]

Is the field that you are applying the criteria to a text field or a number
field?
Post the SQL of your query with the criteria by opening in design view,
click on VIEW - SQL View, highlight all, copy, and paste in a post.