very very simple query just not working

[swarv]

I have: 
 
SELECT tbl_users.Name, tbl_users.bradfordscore
FROM tbl_users
WHERE (((tbl_users.bradfordscore)>"75"));

but it returns a user whose score is 9 and not the user whose score is 125.

What would be the reason for this?

thanks

 

[gemma-the-husky]

are your bradfordscores defined as TEXT, or numbers in your table

if strings, then in fact 9 IS greater than 75, or more correctly comes AFTER 75, when sorted alphabetically
Note that your query will just return the first (random) row greater than 75

 

[swarv]

the bradfordscore fields are TEXT.
without changing the whole table fields into number is there are way the query can think these are numbers?
thanks gemma.

 

[swarv]

i have changed it to number

thanks again gemma

 

[gemma-the-husky]

SELECT tbl_users.Name, tbl_users.bradfordscore
FROM tbl_users
WHERE (((tbl_users.bradfordscore)>75));

not sure what a bradford score is, but this will still only give you a (not a particular) record whose bradford score exceeds 75. ie may be 80, 100, 300 -no way of telling which one you will get


IGNORE THIS

I am being silly, it will give you all of them

i was thinking of a dlookup, which will jsut give you one example

 

[swarv]

hehe, one of those days. especially for me as i only have 1 hour left at work and then im job less. being made redundant today.

cheers