sum up different bank account

12 posts
Re: sum up different bank account
User avatar
Renato
Super MMEX User

Posts: 106
Joined: Mon Apr 25, 2011 1:36 pm
Hi Nikolay

Thanks, this is precisely the evaluation I needed.

However, I have in SQL
order by ACCOUNT NAME;
by
order by HELDAT,ACCOUNT NAME;
replaced.

And in html
<th class = "i18n"> Balance </th>
<th class = "i18n"> Conv rate </th>
<th class = "i18n"> Balance </th>
by
<th class = "text-right"> Balance </th>
<th class = "text-right"> Conv rate </th>
<th class = "text-right"> Balance </th>
replaced.
regards Renato

use MMEX since 2009
Re: sum up different bank account
User avatar
Renato
Super MMEX User

Posts: 106
Joined: Mon Apr 25, 2011 1:36 pm
and a.accountname like 'CS%' or a.accountname like 'SG%' or a.accountname like '.%' or a.accountname like 'Spar%' or a.accountname like 'Post%'

Code: Select all
and a.accountname in( 'CS..', 'SG..' , 'Spar..', 'Post..')
list full names for all needed accounts
regards Renato

use MMEX since 2009
Who is online

Users browsing this forum: No registered users and 1 guest

cron