Greatest Values Question

[FoFa]

Interesting, I just downloaded it and there is a query3

 

[Tiro Cupidus]

There is a Query3 for me and it runs smoothly.

 

[namliam]

Re: Greatest Values

ok here is and example:

I have

0
-1
-2
-8
-4
-5
-6
-7
-8
-8
-9
-9
-1
0
-2
-3


Out of that I need to get -7 -8 -8 -9 -9 and not just get the first 5 values.

Isnt this what I and others have given you OVER AND OVER????

I took your above data and used MY query:
SELECT TOP 5 Table1.Field1 FROM Table1 ORDER BY Table1.Field1 ASC
Returning:
Field1
-9
-9
-8
-8
-8

Then using the same query and your SECOND sample (the huge list of 94 values) it returns
Field1
-8
-5
-2
-2
-2
-2

So tell me WHAT THE FLIPPING BLIIIIIEEEEEP IS WRONG WITH THAT??!?!!?!?!?!?!?!?!?!?!?!?!!

Aaaaaaargh !!!!!!

Regards

The "still patient" Mailman

 

[Mile-O]

Re: Re: Greatest Values

The "still patient" Mailman

It'll be mental patient if this keeps up.

 

[namliam]

I was diagnosed as crazy long before i joined the forum But they gave up on trying to "cure" me So now i am "out and about"

Regards