Quering Number Range in Text Field

[Hillary]

I am working in a purchased database trying to extract scores. The scores are stored in a text field. I want to extract all scores 64 and below.

The formula <"65" Or "7" Or "8" Or "9" works except for a student with a perfect score of 100. In text, 100 is less than 65.

The formula <"65" Or "7" Or "8" Or "9" And Not Like "100" still retuns scores of 100.

What is the correct formula for extracting all scores <65, not including 100 from a text field?

Thanks,

Hillary

 

[PHV]

Something like this ?
WHERE CInt([name of scores field])<65

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Hillary]

This is worked on Monday. When I open the query now I get #Error in this field instead of the result of ScaledScoreConvert: CInt([SCALED_SCORE]). Some of the records on this table have a P or F in [Scaled_Score] but not in any of the records I'm trying to query.

Anyway around this???

Thanks!

Hillary

 

[PHV]

And this ?
WHERE IsNumeric([SCALED_SCORE]) And Val([SCALED_SCORE])<65

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244