T
tanhus
I have a table that contains the following fields. Every 3 months i recieve a
book value and MTM, i then have to use the last set of values to calculate
the closing value. how can i build a query and an update query to do this.
here is the example
Table = [MTM - Securitized Assets]
Entity Book Value MTM Closing Value Date
ABC 10 10 20
Dec
ABC 10 5
Apr
I want to build a query to perform a simple calculation so that it looks
like this
Entity Closing Value Dec Book Value Apr MTM Apr Closing
Value Apr
ABC 20 10 5
35
Basically the calculation looks like this
[Closing Value Dec]+[Book Value Apr]+[MTM Apr]=[Closing Value Apr]
I then want to take this query and update my original table so that entity
ABC at Apr will have a closing Value of 35.
Does anyone know how to build these queries for me?
Thanks to those who can help.
book value and MTM, i then have to use the last set of values to calculate
the closing value. how can i build a query and an update query to do this.
here is the example
Table = [MTM - Securitized Assets]
Entity Book Value MTM Closing Value Date
ABC 10 10 20
Dec
ABC 10 5
Apr
I want to build a query to perform a simple calculation so that it looks
like this
Entity Closing Value Dec Book Value Apr MTM Apr Closing
Value Apr
ABC 20 10 5
35
Basically the calculation looks like this
[Closing Value Dec]+[Book Value Apr]+[MTM Apr]=[Closing Value Apr]
I then want to take this query and update my original table so that entity
ABC at Apr will have a closing Value of 35.
Does anyone know how to build these queries for me?
Thanks to those who can help.