Hi Padmaja
The correct syntax is as follows:
select LedgerTrans where LedgerTrans.Accountnum >= '1000' &&
LedgerTrans.AccountNUm <= '2000' && LedgerTrans.TransDate == 1\1\2004 &&
LedgerTrans.Voucher like 'F111*';
LedgerTrans.AccountNUm <= '2000' && LedgerTrans.TransDate == 1\1\2004 &&
LedgerTrans.Voucher like 'F111*';
Varden Morris
J. Wray & Nephew Ltd. - Group I.S.
Phone: (876) - 923 - 6141 Ext. 2226
Fax: (876) - 923 - 5372
Cell: (876) - 3833566
Email: [EMAIL PROTECTED]
Padmaja Iyingar <[EMAIL PROTECTED]> wrote:
Hi ,I am trying to select Sum of accounts's AmoustMST for that particular Voucher series.///For example I want to sum up all accounts only for the voucher F111*.I can not do a substr in the select WHERE clause as its a database field.'select LedgerTrans where LedgerTrans.Accountnum >= 1000 && LedgerTrans.AccountNUm <=2000 && LedgerTrans.TrandsDate= 1\1\2004 && LedgerTrans.Voucher == 'F111%' is not working......I thought F111% is equal to F111*.How can I selectively select this one?.Can some one help please?Thanks,Padmaja Iyer.__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sharing the knowledge on Axapta.
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
Sharing the knowledge on Axapta.
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
