Help - Need Help with Criteria

  • Thread starter Thread starter Chris2122000
  • Start date Start date
C

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!~!
 
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
 
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.
 
Back
Top