Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Nov:2007
    Location: Bulgaria
    Posts: 10

    Êàê äà êîíâåðòèðàì öèôðèòå/âàëóòàòà â äóìè â ACCESS 2007

    Çäðàâåéòå,
    ïðàâÿ áàçà äàííè íà Àêñåñ 2007 çà íóæäèòå íà ìàëêàòà ìè ôèðìà è ìè ñå èñêà àâòîìàòè÷íî íàïèñàíèòå îò ìåí ÷èñëà (ñóìè â ëåâà) â äàäåíà êîëîíà äà áúäàò êîíâåðòèðàíè â äóìè â ñëåäâàùàòà êîëîíà. ×åòîõ íÿêîè íåùà â íåòà, íî îáùî âçåòî íå ìîæàõ äà ñå "ñâåòíà" ìíîãî.
    Ùå Âè áúäà áëàãîäàðåí çà ïîìîùà!
    Ïîçäðàâè!
    Last edited by setix; 1st April 2008 at 17:33.

  2. #2
    Registered User entium's Avatar
    Join Date: May:2003
    Location: Ðóñå
    Posts: 1,426
    Òåãëèø òîâà http://www.shevitza.com/slovom.zip
    Òîâà å ïèñàíî çà Åêñåë íî ðàáîòè è â Àêñåñ.Îòâàðÿø slovom.xls.Ïîñëå îòèâàø â Visual Basic Editor îò Tools--Macros.Êîïèðàø ñúäúðæàíèåòî íà Module1 â êëèïáîðäà.
    Îòâàðÿø àêñåñêàòà ñè òàáëèöà è ïðàâèø åäèí ìîäóë â íåÿ ïîñëå ñëàãàø âúòðå ñúäúðæàíèåòî íà êëèïáîðäà.
    Ïîñëå ïèøåø åäíà çàÿâêà ïîäîáíà íà òàçè
    SELECT Table1.abc, leva([abc]) AS Expr1
    FROM Table1;
    è ñè â áèçíåñà.

  3. #3
    Registered User
    Join Date: Nov:2007
    Location: Bulgaria
    Posts: 10
    Áëàãîäàðÿ!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè