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
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
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