J
jeremy
I used knowledge base article 120608 example number 2 to
create a rank function. I now want to update that rank
function to another table so I could use it to group those
rankings into quartiles, but I am getting the error
message that the operation must be an updatable query. Any
ideas how to easily fix this? I would like to do this
quartile assignment for 75 dates, so any ideas there would
be appreciated too.
If you have a response, maybe you could email me directly--
that would be great. thanks.
My two queries used to generate the ranking are called "PE"
SELECT Moodys.PERMNO, Moodys.Date, Moodys.[P-E]
FROM Moodys
WHERE (((Moodys.Date)=#12/31/1926#))
ORDER BY Moodys.[P-E];
And PERANK:
SELECT DISTINCTROW PE1.PERMNO, PE1.Date, (Select Count(*)
From PE where [p-e]<[pe1].[p-e])+1 AS Ranking
FROM PE AS PE1;
create a rank function. I now want to update that rank
function to another table so I could use it to group those
rankings into quartiles, but I am getting the error
message that the operation must be an updatable query. Any
ideas how to easily fix this? I would like to do this
quartile assignment for 75 dates, so any ideas there would
be appreciated too.
If you have a response, maybe you could email me directly--
that would be great. thanks.
My two queries used to generate the ranking are called "PE"
SELECT Moodys.PERMNO, Moodys.Date, Moodys.[P-E]
FROM Moodys
WHERE (((Moodys.Date)=#12/31/1926#))
ORDER BY Moodys.[P-E];
And PERANK:
SELECT DISTINCTROW PE1.PERMNO, PE1.Date, (Select Count(*)
From PE where [p-e]<[pe1].[p-e])+1 AS Ranking
FROM PE AS PE1;