walidkamel245
New member
- Local time
- Today, 01:10
- Joined
- Jul 13, 2023
- Messages
- 9
SELECT TransActions.TransID, TransActions.TransDate, TransActions.MZ, Sum(MoneyMoves.Debit) AS Totol
FROM TransActions INNER JOIN MoneyMoves ON TransActions.TransID = MoneyMoves.TransID
GROUP BY TransActions.TransID, TransActions.TransDate, TransActions.MZ;
رقم الحساب | الحساب | مدين | دائن | رقم السند | شرح الحركة |
---|---|---|---|---|---|
91009004 | ASS-TRANSPORTATION & CARS | 90,348.00 | 0.00 | 2 | |
95095001 | PREVIOUS YEAR P& L | 0.00 | 90,348.00 | 2 | |
91009004 | ASS-TRANSPORTATION & CARS | 90,348.00 | 0.00 | 2 | |
95095001 | PREVIOUS YEAR P& L | 0.00 | 90,348.00 | 2 | |
I found I get this in all arabic written databases. Only solution i found is to create a new DB and import.And I get
No. We would have to import into an english version. I do not think there is something you can do on your end.ok thnk you i will make chang and import
I just tried importing into a new DB amd got the same issue?No. We would have to import into an english version. I do not think there is something you can do on your end.
Still getany one help pls
Insert into TransActions1 select * from TransActions
Insert into MoneyMoves1 SELECT TransID, AccID, Debit,Credit,NoRec, Note FROM MoneyMoves
CurrentDb.Execute "Insert into TransActions1 (select * from TransActions"
CurrentDb.Execute "Insert into MoneyMoves1 (SELECT TransID, AccID, Debit,Credit,NoRec, Note FROM MoneyMoves)"