RANKING

Dear gambler:

After a few minutes on the phone, I think I know what was missing.
I'll correlate this a bit differently:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.tTRK = T.tTRK AND T1.tDATE = T.tDATE
AND T1.nRACE = T.nRACE
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
ORDER BY tTRK, tDATE, tRACE

It now seems almost obvious this had to be what you wanted, now that I
have a few facts I was missing before.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Wed, 27 Oct 2004 08:21:01 -0500, Tom Ellison
wrote:

Dear Gambler:

What I did not know before is that you want to apply this ranking to
each race. In order to do this, I must know the definition of what is
a race. Then the query can rank the results race-by-race, rather than
for all races taken together.

Assuming that nRACE defines a race, the query could be:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.nRACE = T.nRACE
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T

Please notice the change involves simply equating nRACE in the
subquery. If there are other columns necessary to delineate one race
from another, add them similarly with the AND conjunction.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 26 Oct 2004 17:05:07 -0700, "gambler"
wrote:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1, (SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
WHERE (((T.tDATE)=#8/13/2004#) AND ((T.nRACE)=1) AND ((T.xPL)=5));
Hi Tom
I hope I used the right formula you made for me. I had a hard time telling
if I used the correct one. This is a query of one race with the EXPR1 in
Asending order. Instead of the ranking going from 1 to 10, it has all those
high numbers. What Im trying to do is look at the winner of a 100 races and
see how many times the winner was in the top 5 ranking of EXPR1. The query I
sent you was of one race. If I confusing you let me know and Ill try and be
more detailed.
Sure appreciate the help
ed

"Tom Ellison" wrote:

Dear Gambler:

I'm glad you let me know you have this problem. I'd rather not make
the effort to help you and fail because you don't know how to use the
help I sent.

I suggest you create a new query and open the SQL View of that query
using the control right under the File menu in the upper left hand
corner of the screen. Click on the arrow pointed downward to open a
list of options and choose SQL View. Paste in the text I sent and
save it as a new query. You can then run and test it.

In this newsgroup, almost all exchanges are SQL View because this is
text and can be sent back and forth precisely.

Please let me know how this is coming along for you.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 26 Oct 2004 13:03:01 -0700, "gambler"
wrote:

Hi Tom
Im a little confused as this is the first time I used this board. I believe
you answered my question, but I dont know where to type your answer in my
query so I can find out if it works for me. If you did answer my question,
where do I type it in my query and what do I type in? Hope Im not upsetting
you with my stupitity.
I truly appreciate your help
ed

"Tom Ellison" wrote:

Dear Gambler:

SELECT tTRK, tDATE, nRACE, nDIST, tSURF, tCLA, tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1, xPL,f
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank
FROM ALL_HX4 T
WHERE tTRK = "MNR" AND tDATE = #10/10/2004#;

So, is it working?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Mon, 25 Oct 2004 15:51:03 -0700, "gambler"
wrote:

SELECT ALL_HX4.tTRK, ALL_HX4.tDATE, ALL_HX4.nRACE, ALL_HX4.nDIST,
ALL_HX4.tSURF, ALL_HX4.tCLA, ALL_HX4.tPGM, [nTRNITM]+[nJKYITM]+[nTJ] AS
Expr1, ALL_HX4.xPL
FROM ALL_HX4
WHERE (((ALL_HX4.tTRK)="MNR") AND ((ALL_HX4.tDATE)=#10/10/2004#));
Tom
I missed one key element in my last post. I forgot xPL. If it is still
possible could you add it to your formula. Im sorry I just forgot it. I sure
appreciate you help. You dont know how happy it makes one to come this close
to getting answer to something that I have been looking for a long long time.
If it is too much trouble to add xPl, I will be happy with whatever help you
give me. Just tell me where I type it in.

Thanks again
ed

"Tom Ellison" wrote:

Dear Ed:

First, I'll modify your query a bit:

SELECT tTRK, tDATE, nRACE, nDIST, tSURF, tCLA, tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank
FROM ALL_HX4 T
WHERE tTRK = "MNR" AND tDATE = #10/10/2004#;

That does make it easier to modify.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Sun, 24 Oct 2004 14:43:03 -0700, "gambler"
wrote:

SELECT ALL_HX4.tTRK, ALL_HX4.tDATE, ALL_HX4.nRACE, ALL_HX4.nDIST,
ALL_HX4.tSURF, ALL_HX4.tCLA, ALL_HX4.tPGM, [nTRNITM]+[nJKYITM]+[nTJ] AS Expr1
FROM ALL_HX4
WHERE (((ALL_HX4.tTRK)="MNR") AND ((ALL_HX4.tDATE)=#10/10/2004#));

Here is a simpler query [I think]. I might be able to take a few things out
of it. The info all comes from same table. The only thing I would change from
time to time is the Expr1. Maybe this will make things easier.
Where at in the query do I type in your answer. Select*(Select
Count(*)+/From etc. ?
I sure appreciate your help. Im trying my best to help without being to
dumb. But without you Im lost.
Thanks again ed

"gambler" wrote:

I have a list of numbers( that come from a formula--Eg. FR1 + FR2) in one of
my query fields. I would like to take these numbers and give them a ranking.
The highest number would be ranked number1, the second highest number would
be ranked number 2 etc. I would appreciate any help you would give me on how
I could rank these numbers.
I am using Windows Xp and have Office 2000.
Thanks ed

Now, correlating for the pace line:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.tTRK = T.tTRK AND T1.tDATE = T.tDATE
AND T1.nRACE = T.nRACE AND T1.xPL = T.xPL
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
ORDER BY tTRK, tDATE, nRACE, xPL

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 02 Nov 2004 20:22:31 -0600, Tom Ellison
wrote:

Dear gambler:

After a few minutes on the phone, I think I know what was missing.
I'll correlate this a bit differently:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.tTRK = T.tTRK AND T1.tDATE = T.tDATE
AND T1.nRACE = T.nRACE
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
ORDER BY tTRK, tDATE, nRACE

It now seems almost obvious this had to be what you wanted, now that I
have a few facts I was missing before.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Wed, 27 Oct 2004 08:21:01 -0500, Tom Ellison
wrote:

Dear Gambler:

What I did not know before is that you want to apply this ranking to
each race. In order to do this, I must know the definition of what is
a race. Then the query can rank the results race-by-race, rather than
for all races taken together.

Assuming that nRACE defines a race, the query could be:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.nRACE = T.nRACE
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T

Please notice the change involves simply equating nRACE in the
subquery. If there are other columns necessary to delineate one race
from another, add them similarly with the AND conjunction.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 26 Oct 2004 17:05:07 -0700, "gambler"
wrote:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1, (SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
WHERE (((T.tDATE)=#8/13/2004#) AND ((T.nRACE)=1) AND ((T.xPL)=5));
Hi Tom
I hope I used the right formula you made for me. I had a hard time telling
if I used the correct one. This is a query of one race with the EXPR1 in
Asending order. Instead of the ranking going from 1 to 10, it has all those
high numbers. What Im trying to do is look at the winner of a 100 races and
see how many times the winner was in the top 5 ranking of EXPR1. The query I
sent you was of one race. If I confusing you let me know and Ill try and be
more detailed.
Sure appreciate the help
ed

"Tom Ellison" wrote:

Dear Gambler:

I'm glad you let me know you have this problem. I'd rather not make
the effort to help you and fail because you don't know how to use the
help I sent.

I suggest you create a new query and open the SQL View of that query
using the control right under the File menu in the upper left hand
corner of the screen. Click on the arrow pointed downward to open a
list of options and choose SQL View. Paste in the text I sent and
save it as a new query. You can then run and test it.

In this newsgroup, almost all exchanges are SQL View because this is
text and can be sent back and forth precisely.

Please let me know how this is coming along for you.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 26 Oct 2004 13:03:01 -0700, "gambler"
wrote:

Hi Tom
Im a little confused as this is the first time I used this board. I believe
you answered my question, but I dont know where to type your answer in my
query so I can find out if it works for me. If you did answer my question,
where do I type it in my query and what do I type in? Hope Im not upsetting
you with my stupitity.
I truly appreciate your help
ed

"Tom Ellison" wrote:

Dear Gambler:

SELECT tTRK, tDATE, nRACE, nDIST, tSURF, tCLA, tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1, xPL,f
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank
FROM ALL_HX4 T
WHERE tTRK = "MNR" AND tDATE = #10/10/2004#;

So, is it working?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Mon, 25 Oct 2004 15:51:03 -0700, "gambler"
wrote:

SELECT ALL_HX4.tTRK, ALL_HX4.tDATE, ALL_HX4.nRACE, ALL_HX4.nDIST,
ALL_HX4.tSURF, ALL_HX4.tCLA, ALL_HX4.tPGM, [nTRNITM]+[nJKYITM]+[nTJ] AS
Expr1, ALL_HX4.xPL
FROM ALL_HX4
WHERE (((ALL_HX4.tTRK)="MNR") AND ((ALL_HX4.tDATE)=#10/10/2004#));
Tom
I missed one key element in my last post. I forgot xPL. If it is still
possible could you add it to your formula. Im sorry I just forgot it. I sure
appreciate you help. You dont know how happy it makes one to come this close
to getting answer to something that I have been looking for a long long time.
If it is too much trouble to add xPl, I will be happy with whatever help you
give me. Just tell me where I type it in.

Thanks again
ed

"Tom Ellison" wrote:

Dear Ed:

First, I'll modify your query a bit:

SELECT tTRK, tDATE, nRACE, nDIST, tSURF, tCLA, tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank
FROM ALL_HX4 T
WHERE tTRK = "MNR" AND tDATE = #10/10/2004#;

That does make it easier to modify.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Sun, 24 Oct 2004 14:43:03 -0700, "gambler"
wrote:

SELECT ALL_HX4.tTRK, ALL_HX4.tDATE, ALL_HX4.nRACE, ALL_HX4.nDIST,
ALL_HX4.tSURF, ALL_HX4.tCLA, ALL_HX4.tPGM, [nTRNITM]+[nJKYITM]+[nTJ] AS Expr1
FROM ALL_HX4
WHERE (((ALL_HX4.tTRK)="MNR") AND ((ALL_HX4.tDATE)=#10/10/2004#));

Here is a simpler query [I think]. I might be able to take a few things out
of it. The info all comes from same table. The only thing I would change from
time to time is the Expr1. Maybe this will make things easier.
Where at in the query do I type in your answer. Select*(Select
Count(*)+/From etc. ?
I sure appreciate your help. Im trying my best to help without being to
dumb. But without you Im lost.
Thanks again ed

"gambler" wrote:

I have a list of numbers( that come from a formula--Eg. FR1 + FR2) in one of
my query fields. I would like to take these numbers and give them a ranking.
The highest number would be ranked number1, the second highest number would
be ranked number 2 etc. I would appreciate any help you would give me on how
I could rank these numbers.
I am using Windows Xp and have Office 2000.
Thanks ed

Thanks for helping me. All appears to be working fine. For anyone out there
that needs help, once Tom understands what you want to do, he can do it.
Thanks for doing what I didnt think could be done.
Thanks Tom
ed

"Tom Ellison" wrote:

Now, correlating for the pace line:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.tTRK = T.tTRK AND T1.tDATE = T.tDATE
AND T1.nRACE = T.nRACE AND T1.xPL = T.xPL
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
ORDER BY tTRK, tDATE, nRACE, xPL

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 02 Nov 2004 20:22:31 -0600, Tom Ellison
wrote:

Dear gambler:

After a few minutes on the phone, I think I know what was missing.
I'll correlate this a bit differently:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.tTRK = T.tTRK AND T1.tDATE = T.tDATE
AND T1.nRACE = T.nRACE
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
ORDER BY tTRK, tDATE, nRACE

It now seems almost obvious this had to be what you wanted, now that I
have a few facts I was missing before.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Wed, 27 Oct 2004 08:21:01 -0500, Tom Ellison
wrote:

Dear Gambler:

What I did not know before is that you want to apply this ranking to
each race. In order to do this, I must know the definition of what is
a race. Then the query can rank the results race-by-race, rather than
for all races taken together.

Assuming that nRACE defines a race, the query could be:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.nRACE = T.nRACE
AND T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T

Please notice the change involves simply equating nRACE in the
subquery. If there are other columns necessary to delineate one race
from another, add them similarly with the AND conjunction.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 26 Oct 2004 17:05:07 -0700, "gambler"
wrote:

SELECT T.tTRK, T.tDATE, T.nRACE, T.nDIST, T.tSURF, T.tCLA, T.tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1, (SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank, T.tHOR, T.xPL
FROM ALL_HX4 AS T
WHERE (((T.tDATE)=#8/13/2004#) AND ((T.nRACE)=1) AND ((T.xPL)=5));
Hi Tom
I hope I used the right formula you made for me. I had a hard time telling
if I used the correct one. This is a query of one race with the EXPR1 in
Asending order. Instead of the ranking going from 1 to 10, it has all those
high numbers. What Im trying to do is look at the winner of a 100 races and
see how many times the winner was in the top 5 ranking of EXPR1. The query I
sent you was of one race. If I confusing you let me know and Ill try and be
more detailed.
Sure appreciate the help
ed

"Tom Ellison" wrote:

Dear Gambler:

I'm glad you let me know you have this problem. I'd rather not make
the effort to help you and fail because you don't know how to use the
help I sent.

I suggest you create a new query and open the SQL View of that query
using the control right under the File menu in the upper left hand
corner of the screen. Click on the arrow pointed downward to open a
list of options and choose SQL View. Paste in the text I sent and
save it as a new query. You can then run and test it.

In this newsgroup, almost all exchanges are SQL View because this is
text and can be sent back and forth precisely.

Please let me know how this is coming along for you.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Tue, 26 Oct 2004 13:03:01 -0700, "gambler"
wrote:

Hi Tom
Im a little confused as this is the first time I used this board. I believe
you answered my question, but I dont know where to type your answer in my
query so I can find out if it works for me. If you did answer my question,
where do I type it in my query and what do I type in? Hope Im not upsetting
you with my stupitity.
I truly appreciate your help
ed

"Tom Ellison" wrote:

Dear Gambler:

SELECT tTRK, tDATE, nRACE, nDIST, tSURF, tCLA, tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1, xPL,f
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank
FROM ALL_HX4 T
WHERE tTRK = "MNR" AND tDATE = #10/10/2004#;

So, is it working?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Mon, 25 Oct 2004 15:51:03 -0700, "gambler"
wrote:

SELECT ALL_HX4.tTRK, ALL_HX4.tDATE, ALL_HX4.nRACE, ALL_HX4.nDIST,
ALL_HX4.tSURF, ALL_HX4.tCLA, ALL_HX4.tPGM, [nTRNITM]+[nJKYITM]+[nTJ] AS
Expr1, ALL_HX4.xPL
FROM ALL_HX4
WHERE (((ALL_HX4.tTRK)="MNR") AND ((ALL_HX4.tDATE)=#10/10/2004#));
Tom
I missed one key element in my last post. I forgot xPL. If it is still
possible could you add it to your formula. Im sorry I just forgot it. I sure
appreciate you help. You dont know how happy it makes one to come this close
to getting answer to something that I have been looking for a long long time.
If it is too much trouble to add xPl, I will be happy with whatever help you
give me. Just tell me where I type it in.

Thanks again
ed

"Tom Ellison" wrote:

Dear Ed:

First, I'll modify your query a bit:

SELECT tTRK, tDATE, nRACE, nDIST, tSURF, tCLA, tPGM,
[nTRNITM]+[nJKYITM]+[nTJ] AS Expr1,
(SELECT COUNT(*) + 1 FROM ALL_HX4 T1
WHERE T1.[nTRNITM] + T1.[nJKYITM] + T1.[nTJ]
T.[nTRNITM] + T.[nJKYITM] + T.[nTJ]) AS Rank
FROM ALL_HX4 T
WHERE tTRK = "MNR" AND tDATE = #10/10/2004#;

That does make it easier to modify.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts


On Sun, 24 Oct 2004 14:43:03 -0700, "gambler"
wrote:

SELECT ALL_HX4.tTRK, ALL_HX4.tDATE, ALL_HX4.nRACE, ALL_HX4.nDIST,
ALL_HX4.tSURF, ALL_HX4.tCLA, ALL_HX4.tPGM, [nTRNITM]+[nJKYITM]+[nTJ] AS Expr1
FROM ALL_HX4
WHERE (((ALL_HX4.tTRK)="MNR") AND ((ALL_HX4.tDATE)=#10/10/2004#));

Here is a simpler query [I think]. I might be able to take a few things out
of it. The info all comes from same table. The only thing I would change from
time to time is the Expr1. Maybe this will make things easier.
Where at in the query do I type in your answer. Select*(Select
Count(*)+/From etc. ?
I sure appreciate your help. Im trying my best to help without being to
dumb. But without you Im lost.
Thanks again ed

"gambler" wrote:

I have a list of numbers( that come from a formula--Eg. FR1 + FR2) in one of
my query fields. I would like to take these numbers and give them a ranking.
The highest number would be ranked number1, the second highest number would
be ranked number 2 etc. I would appreciate any help you would give me on how
I could rank these numbers.
I am using Windows Xp and have Office 2000.
Thanks ed