well i done this so far
what i have in mind is in one invoice i can add many products with it's price ad quantity showing it's total,
and for one customer to show how many invoices the customer bought with the total of each invoice.
but that's seem not working in the saving way for the tables or what am i doing wrong , how to make the grid to show only new items of products for new invoice and not all the records of the table
1 2021-08-21 02:43:43
Re: Sqlquery calculated field summation error (10 replies, posted in SQL queries)
2 2021-08-13 17:26:27
Re: Sqlquery calculated field summation error (10 replies, posted in SQL queries)
derek wrote:
It's difficult to offer any help without seeing your project (your link won't work for many of us based in Europe as zippyshare is blocked).
Delete the .exe file from your application and upload the remaining files as a .zip file.
Then explain as fully as possible exactly what you are trying to do.
Derek.
i'm not sure exactly what i'm doing wrong
i'm making an invoice application, to track customers purchases, payments and debets
i made products table, customer table and invoice detail table
so what i want is
when i create new invoice to select products and it's prices multiplication in it's quantities, for one invoice contain many products and to be linked to customer name and date.
i'm still working on it but the issue is when i try to make new invoice the DGV (data grid view) shows all the previous records while i want to make new invoice without old records
3 2021-08-09 11:47:23
Re: Sqlquery calculated field summation error (10 replies, posted in SQL queries)
How can that be done, since invoice total value includes many products values * it's prices
I don't have one field to be linked to
4 2021-07-27 16:02:37
Re: Sqlquery calculated field summation error (10 replies, posted in SQL queries)
i had to upload my project to zippyshare cause of The selected file was too large to upload
and uploaded file with it's link cause no links are allowed
the issue is in table dept
5 2021-07-27 12:08:39
Topic: Sqlquery calculated field summation error (10 replies, posted in SQL queries)
i have invoice table with calculated field that calculate amount multiple price to give total value and that for each customer
with this query "(select productP from products where invoices.id_products = products.id) * invoices.quantity "
i mad new table called dept where i want to show how much total invoice had one customer bought , but i get error with query
"select total from invoices where dept.id_invoices = invoices.id"
also made column settings formula = sum in tablegrid
i upload the error message