Hi Folks
I have a fixed Assets program which keeps records of company fixed Assets.There is a facility for revaluing the Fixed Assets periodically and the program works fine.Now it has become necessary to revalue some assets more than once per year and the query that reports revaluation movements per year is now duplicating values. The Revaluation movement is the difference between the Purchase price and the last Revalued amount.An Assets which has been revalued will have a value in the last revalued date field in the Revaluation History table.The filtering I want is for the program to select the revaluation movement based on the Difference between the purchase price and the last revalued amount for assets , where an assets has been revalued more that once this value should be based on the last revalued transaction for that asset.
I have tried this code with no success
AMaxValue: DMax("RH_ID","QryAssetsCostsR","Assetid"="Assetid")
It Fetches all the records
Can Someone Please help
I have a fixed Assets program which keeps records of company fixed Assets.There is a facility for revaluing the Fixed Assets periodically and the program works fine.Now it has become necessary to revalue some assets more than once per year and the query that reports revaluation movements per year is now duplicating values. The Revaluation movement is the difference between the Purchase price and the last Revalued amount.An Assets which has been revalued will have a value in the last revalued date field in the Revaluation History table.The filtering I want is for the program to select the revaluation movement based on the Difference between the purchase price and the last revalued amount for assets , where an assets has been revalued more that once this value should be based on the last revalued transaction for that asset.
I have tried this code with no success
AMaxValue: DMax("RH_ID","QryAssetsCostsR","Assetid"="Assetid")
It Fetches all the records
Can Someone Please help