Easy help

[chisigs2]

I havent messed w/ Access in a while..... so this is an easy one. I am making a Query.. and it has FICO scores and i want to only show a range of scores.... ex: 350-399 under Criteria I tried >"349"<"400" and that doenst seem to work... what am I leaving out?

 

[Norie]

Try Between 350 and 399

 

[chisigs2]

That returns no results

 

[Norie]

What's the field type?

 

[chisigs2]

it is text.... they are all 3 digit numbers

 

[Norie]

Change the field type to number.

I tried with the field type text with numbers 1-1489.

Using Between "350" and "399" worked sort of - itreturned some weird values like 36, 37 etc

When I changed the field type to number and used Between 350 and 399 it worked properly.

 

[chisigs2]

Great that worked.... thanks.....