Balance and Movements

[avicentbarcelo]

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

[varshavig12]

Can you provide us with some sample data and the expected output ?

[ElizaF]

Hello,

You can use the "As Of Table" concept. See below the link:

The As-Of Table

[Anil_Babu_Samineni]

I Recommend you to don't create two threads for single Issue

Please get back my response. So that, We can look in deep.

Balance and Movements