Percentage Difference Between two fields?

[natonstan]

typed it too late

Ok with AND at the end of the second to last line, I'm getting this error:

Syntax error in query expression '(select top (1) t2.LastSalesRateChangeDate
from tblForEx as t2
where t2.BaseCur= t.BaseCur and t2.ForCur =t.ForCut
t2.LastSalesRateChangDate < t.LastSalesRateChangeDate
order by t2.LastSalesRateChangeDate desc


)',

[natonstan]

I've managed to get the percentages to show using this code:

SELECT t2.*, (SELECT top 1 t.ForExRate
FROM tblForEx t
where t.BaseCur=t2.BaseCur AND t.ForCur=t2.ForCur and t.LastSalesRateChangeDate<t2.LastSalesRateChangeDa te
order by t.LastSalesRateChangeDate DESC, t.ForExRate DESC
) AS PreviousRate, [ForExRate]/[PreviousRate]-1 AS ChangeRatio
FROM tblForEx AS t2;

[Micron]

CROSS POSTED HERE
https://www.mrexcel.com/forum/micros...wo-fields.html
nanostan - please read why this is not cool http://www.excelguru.ca/content.php?184