Problem with Top Value

Hayley Baxter

Registered User.
Local time
Today, 23:55
Joined
Dec 11, 2001
Messages
1,607
I am looking to retrieve the top 10 values by Fee but I am getting some odd results.

This is what I have

Code:
SELECT TOP 10 Get_Lenders_Fee.[Stock description], Get_Lenders_Fee.[SL Fee (Bp)], Get_Lenders_Fee.[Market area]
FROM Get_Lenders_Fee
WHERE (((Get_Lenders_Fee.[SL Fee (Bp)])>"100") AND ((Get_Lenders_Fee.[Market area]) Like "*Govt*"))
ORDER BY Get_Lenders_Fee.[SL Fee (Bp)] DESC;]

I near enough get what I expect but there is 1 odd result thrown in with a negative no which clearly shouldn't be there.

ie
99.550003
980.000019
95.676297
-92.666668

Any ideas?

Thanks
Hay
 

Users who are viewing this thread

Back
Top Bottom