Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I' sorry because my english isn't good.
Forgive me if what I ask is simple to solve, but I'm new and I do not have much practice with QV.
I have a table with the following information:
- Account
- Closing Date
- Balance
With one record for each account and not always all accounts have the same closing date.
and another table with those produced movements, with the following data:
- Account
- Date Movement
- Amount
Given that on a date (Date Movement) may have several records movements and that not all movements have time, I would get a table with the following data.
- Account
- Date
- Balance date (sum of all movements that date)
- Balance on that date
Keep in mind that the Closing Date is greater than or equal to all movement dates from that account.
I would appreciate your help very much.
Regards,
Ana
Can you provide us with some sample data and the expected output ?
I Recommend you to don't create two threads for single Issue
Please get back my response. So that, We can look in deep.