Hello, Can someone helpme please i need to know how we can use the SUM function with our column table for example i need to calculate the Amount of all records but need to split them if row contains 1,2,3 accounts.type: id,name 1 = Expense 2 = Income 3 = Refund so how can we sum every amount of 1 ,2...

Awesome Codenstuff

Thanks ;)

Hello, Can someone help me with this piece :) we have for example 2 amounts first one will be 15.000.00 second one will be 750.00 how can we get the percentage to set with progressbar value? to fill up the bar to see how far we get with the payment when offcource payed everything we must get 100% so...

solved,

i just added a new connection to see if any records exist before we go to the submitted part
and seems that did the trick ;)

making me so ....
search on the net for long time
and still nothing about that part we are looking for
just always with 0 even if empty or not.. always that stupid 0
why can't be there a easier solution hahaha

maybe me

is there a extra way so if no records exist we can get an other message?

instead of 0 maybe false?
so we can use that option when we are loading the db and then we can leave that empty instead of submitted ;)
if you can follow

Hi,

The db is empty
so no records exists yet

Hi,

Yeah , but its not :( it returns 0
and i had a empty db so no records exists

any idea?

Hi, i was wondering if someone could tell me how i can really detect if no records exist or just has only value 'True' in it i use: Dim whereClause As String = "monthid ='" & monthid & "' AND yearid ='" & yearid & "' AND status LIKE '" & Value & ...

Hi,

Okay i will look into it ;)

Thanks