B
Bruce
I have read many of the threads on this forum re: ranking records but still
fail to have any success.
In my query below I have my data is ranked ny the expression
'Capitalisation' and sorted descending. I simply wan to add a calculateded
field to my query that ranks based on my capitalisation results.
Any advise much appreciated.
Bruce
SELECT tbl_Company.ASXCode, round(Avg([tbl_ASX_Data]![Close]),3) AS [Close],
round(Avg([tbl_ASX_Data]![Volume]),0) AS Vol,
round(Avg([tbl_ASX_Data]![Close])*Avg([tbl_ASX_Data]![Volume]),0) AS
Capitalisation
FROM tbl_Company INNER JOIN tbl_ASX_Data ON tbl_Company.ID = tbl_ASX_Data.ID
WHERE
(((tbl_ASX_Data.ImportDate)>Format(DateAdd("yyyy",-1,Date()),"yyyymmdd")))
GROUP BY tbl_Company.ASXCode
ORDER BY round(Avg([tbl_ASX_Data]![Close])*Avg([tbl_ASX_Data]![Volume]),0)
DESC;
fail to have any success.
In my query below I have my data is ranked ny the expression
'Capitalisation' and sorted descending. I simply wan to add a calculateded
field to my query that ranks based on my capitalisation results.
Any advise much appreciated.
Bruce
SELECT tbl_Company.ASXCode, round(Avg([tbl_ASX_Data]![Close]),3) AS [Close],
round(Avg([tbl_ASX_Data]![Volume]),0) AS Vol,
round(Avg([tbl_ASX_Data]![Close])*Avg([tbl_ASX_Data]![Volume]),0) AS
Capitalisation
FROM tbl_Company INNER JOIN tbl_ASX_Data ON tbl_Company.ID = tbl_ASX_Data.ID
WHERE
(((tbl_ASX_Data.ImportDate)>Format(DateAdd("yyyy",-1,Date()),"yyyymmdd")))
GROUP BY tbl_Company.ASXCode
ORDER BY round(Avg([tbl_ASX_Data]![Close])*Avg([tbl_ASX_Data]![Volume]),0)
DESC;