SELECT [ALL_HX4].[tTRK], [ALL_HX4].[tDATE], [ALL_HX4].[nRACE],
[ALL_HX4].[nDIST], [ALL_HX4].[tSURF], [ALL_HX4].[tCLA], [ALL_HX4].[nCLM],
[ALL_HX4].[tPGM], [ALL_HX4].[tHOR], [ALL_HX4].[nPPO], [ALL_HX4].[nMLO],
[ALL_HX4].[nLAY], [ALL_HX4].[nCLch], [ALL_HX4].[xPL], [PL4].[tPL],
[PL4].[nKLINE], [PL5].[tPL], [PL5].[nKLINE], [ALL_HX4].[tCONDS],
[ALL_HX4].[tLTRK], [ALL_HX4].[nLDIST], [ALL_HX4].[nTRCH], [ALL_HX4].[rTRN],
[ALL_HX4].[nTRN], [ALL_HX4].[nJKY], [ALL_HX4].[rJKY], [ALL_HX4].[nJKCH],
[ALL_HX4].[nTRNITM], [ALL_HX4].[nJKYITM], [ALL_HX4].[nWKSC],
[ALL_HX4].[nLiveP], [ALL_HX4].[nLiveS], [ALL_HX4].[nLiveL], [PL4].[rFr1],
[PL5].[rFr1], [PL4].[rEP], [PL5].[rEP], [PL4].[nFR3], [PL5].[nFR3],
[PL4].[rPER], [PL4].[nPER], [PL5].[rPER], [ALL_HX4].[nLDR], [PL4].[nLONG],
[PL5].[nLONG], [PL4].[nKrat], [PL4].[rKrat], [PL5].[nKrat], [PL5].[rKrat],
[ALL_HX4].[tPOST], [ALL_HX4].[nVI], [ALL_HX4].[nQFIVES], [ALL_HX4].[tAGE],
[ALL_HX4].[nPURS], [ALL_HX4].[nPED], [ALL_HX4].[tRS], [ALL_HX4].[nQP],
[ALL_HX4].[nLiveA], [ALL_HX4].[nLAY90], [ALL_HX4].[tCHG],
[ALL_HX5].[nPP1FIN], [ALL_HX5].[nPP2FIN], [ALL_HX5].[nPP3FIN],
[ALL_HX4].[nTJST], [ALL_HX4].[nTJ], [ALL_HX4].[nTRNST], [ALL_HX4].[nJKYST],
[ALL_HX4].[nLSURF], [ALL_HX4].[nTRNHST], [ALL_HX4].[nTRNHW],
[ALL_HX4].[nJKYHST], [ALL_HX4].[nJKYHW], [ALL_HX4].[nTRNW],
[ALL_HX4].[nJKYW], [PL4].[n2FRAW], [PL5].[n2FRAW], [ALL_HX4].[tSEX],
[ALL_HX4].[nHAG], [ALL_HX4].[tLIFE], [ALL_HX4].[tDS], [ALL_HX4].[nCLAT1],
[ALL_HX4].[nCLAT2], [ALL_HX5].[nPP1DIS], [ALL_HX5].[nPP2DIS],
[ALL_HX5].[nPP3DIS], [ALL_HX5].[nPP1SUR], [ALL_HX5].[nPP2SUR],
[ALL_HX5].[nPP3SUR], [ALL_HX5].[nPP1SHF], [ALL_HX5].[nPP2SHF],
[ALL_HX5].[nPP3SHF], [ALL_HX4].[rC90], [ALL_HX4].[rPSCN], [ALL_HX4].[rPFIG],
[ALL_HX4].[rHTR], [ALL_HX4].[nODDS1], [ALL_HX4].[nODDS2], [ALL_HX4].[nODDS3],
[ALL_HX4].[nCLAT3], [nTRNITM]+[nJKYITM]+[nTJ] AS Expr1
FROM ((ALL_HX4 INNER JOIN PL4 ON ([ALL_HX4].[tTRK]=[PL4].[tTRK]) AND
([ALL_HX4].[tDATE]=[PL4].[tDATE]) AND ([ALL_HX4].[nRACE]=[PL4].[nRACE]) AND
([ALL_HX4].[tPGM]=[PL4].[tPGM])) INNER JOIN PL5 ON
([PL4].[tTRK]=[PL5].[tTRK]) AND ([PL4].[tDATE]=[PL5].[tDATE]) AND
([PL4].[nRACE]=[PL5].[nRACE]) AND ([PL4].[tPGM]=[PL5].[tPGM])) INNER JOIN
ALL_HX5 ON ([PL5].[tPGM]=[ALL_HX5].[tPGM]) AND
([PL5].[nRACE]=[ALL_HX5].[nRACE]) AND ([PL5].[tDATE]=[ALL_HX5].[tDATE]) AND
([PL5].[tTRK]=[ALL_HX5].[tTRK])
WHERE ((([ALL_HX4].[tTRK])="mnr") And (([ALL_HX4].[tDATE])=#10/8/2004#) And
(([ALL_HX4].[xPL])=5));
Sorry I didnt respond sooner, I didnt know you responded to my question. In
the very last columb is Expr1. This is the columb I would like to rank. I
sure appreciate your help. Im not to smart when it comes to using access, but
i have some books and I try. Thanks for helping. ed
Tom Ellison said:
Dear Gambler:
You are almost certainly accustomed to working with the Design Grid
view of your queries. There is another view available, the SQL view,
which is available through the icon in the upper left corner, under
the word File. If you pull down the list there, you should see SQL
View as an option. The SQL will then be shown as text, and you can
paste it into your message.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts