User Profile

ashukite · Feb 9 '10, 11:35 AM

I used this and it works,

Code:

SELECT Invoice.[Invoice ID], 
    (Invoice.Quantity * Invoice.[Unit Price]) 
    - Sum(Payment.Amount) AS Remaining
FROM
    Invoice LEFT JOIN Payment ON Invoice.[Invoice ID] = Payment.[Invoice ID]
GROUP BY Invoice.[Invoice ID], Invoice.Quantity, Invoice.[Unit Price]

thanks

ashukite · Feb 8 '10, 11:13 AM

Sorry for not being specific, 'm not experienced in SQL. Thanks for your answer, i'll try it that way

ashukite · Feb 4 '10, 12:56 PM

Thanks I got it i will try it that way!

ashukite · Feb 4 '10, 11:51 AM

how can i calculate the epagomenal dates by code

ashukite · Feb 4 '10, 08:57 AM

I can't get your idea, would you please make it a bit clear?

ashukite · Feb 4 '10, 07:39 AM

I can't get your idea, would you please make it a bit clear?

ashukite · Jan 14 '10, 11:36 PM

i didn't solve this problem. but i deleted the total field from my databse because it is a calculated value. I added a column to my dataset and make its value an expression.

ashukite · Jan 14 '10, 01:46 PM

the text box doesn't accept text. it is validated to accept numeric values only. Besides I tried this
total.text = convert.todecim al(quantity.tex t * unitprice.text) and the result I get on the msgbox is correct result. This is not the case.

ashukite · Jan 13 '10, 05:20 PM

i selected the invice table from the dataset and set it to the detail view and changed the item column control to combobox instead of text box. then set its datasource, displaymember and value member. then i dragged it to the invoice form. then i used the bindingnavigato r's save button to save records. other values from other textboxes are saved except for the item column and total column.

User Profile

Profile Sidebar

Leave a comment:

Crystal report with binding source

Leave a comment:

Sql Subquery with sum

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Is it possible to make a date datatype accept 13 as a month and 30 for all months?

Leave a comment:

Leave a comment:

Calculated value on textChanged event can't be updated to database

Leave a comment:

bindingsource doesn't save some fields