Search results

My apologies, you are not missing anything, I was sleeping... The data is indeed the same as in my previous post and the query should of course return SecID 1!

Please find below sample data from the table Period SecID Price 201206 1 105,00 201207 1 100,00 201208 1 95,00 201209 1 90,00 201210 1 85,00 201207 2 95,00 201208 2 100,00 201209 2 103,00 201210 2 99,00 The evaluation period is 201210 and the threshold is 3%. The...

Thanks for your response. The parameter XX in the formula represents a percentage, the Parameter PriceT represents the price of a security in period T, while the parameter PriceT-1 represents the price of the same security in the previous period. Please find below a simplified example. The...

Hi, I have a table containing amongst others the following attributes: Period (yyyymm) ContractID Price The table contains approximately 3 years of historical information (36 periods). I am trying to write a query that presents the contract details of contracts having a price change of more...

Hi All, My name is Paul and I live in Holland. I am 42 years old and am a frequent user of Excel. Recently I started using MS Access and occassionaly I experience some 'challenges'.. I love boardsports like snowboarding and kitesurfing and try to spend as much time as possible on the water. I...