Forum Discussion
Solved
Sum records where ID is < current ID
Experts, I need to subtract: tblFXRollsChild.Rate I have a datasheet name of "Rate C", from tblFXRollsChild.Rate where ”IDFXParent=” & [tblFXRollsChild].[IDFXParent] And (this is the hard...
it is unclear what you want.
you need to subract tblFXRollsChild.Rate from tblFXRollsChild.Rate on same IDFXParent and
IDRollsPK is less than or equal?
it is best to show some data from both parent and child table.
then show the expected result.
you need to subract tblFXRollsChild.Rate from tblFXRollsChild.Rate on same IDFXParent and
IDRollsPK is less than or equal?
it is best to show some data from both parent and child table.
then show the expected result.
Hi Arnel, yes, that is exactly what I am looking for.
So, in the example above, the math would be:
1.240944 - 1.244714 for IDRollsPk = 36 on Me.IDFXParent
1.244714 - 1.233714 for IDRollsPk = 17 on Me.IDFXParent
I know I cant use Me. though.Also, FYI: tblFXRollsChild.Rate is the field that is named "Rate C" in above pic. I am using a datasheet name in the display so could be slightly confusing since there is no field that is named "Rate C".
let me know if still not clear. thank you sir.
