Post Author: nesaver
CA Forum: General
I have 2 tables :
Sale
SaleID
Date
Money
2. Buy
BuyID
Date
Money
I want to design a report which shows : sum of sale money = A, sum of buy money = B, A-B; in a month. But, if Sale table has 10 rows and Buy table has 3 rows (in specific month), the report that I designed has 30 rows details -> sum of sale money, and sum of buy money are wrong.
Can you help me ?
Thank for support 😊