Dear developpers,
I am stuck in a great problem in my payment analysis form as my calculation of paid and non paid invoices amount could not be calculated and it may be because of the format.
I am using A form "Creation Facture" to generate invoice and then copy data from invoice sheet "Facture Simple" to database sheet "BDD" via a button "Créer"
The problem is in calculation displayed in the tracking and analysis form "Suivi & Analyse" as shown in this picture:Calculation.jpg
though the calculation is correct.
I want also to prevent duplicate entery in "BDD" when clicking again on "créer"data.jpg
Herewith my file for any amendments for the codes I am using
Thanks in advance,
Reply With Quote