Forum Discussion

iurilino's avatar
iurilino
Frequent Visitor
8 years ago
Solved

Reationship

Hello, I'm sorry for my bad English beforehand, the following happens: I have two tables ('DUPLICATAS [Centro]', 'ESTMOVIMENTO [CODCCU]') that are linked by the CENTRO table [Code], I need the summation per month of ' DUPLICATAS [Center] 'and' ESTMOVIMENTO [CODCCU] ', only that there are some values ​​that are in' ESTMOVIMENTO [CODCCU] 'that are not in' DUPLICATAS [Center] ', when I bring the filtered somátorio per month of ESTMOVIMENTO, brings the overall sum of DUPLICATAS in the year by month, and not only per month. I have already tried using tb. Follow the pictures as an illustration and with the relationship made. Remembering what I'm doing with the CODCCU filter = 207007.

 

https://ibb.co/gdKXF9

https://ibb.co/hGiba9

 

Thanks!

2 Replies