Results 1 to 5 of 5

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Mar:2005
    Location: Ñîôèÿ
    Posts: 208

    Íå óñïÿâàì äà íàêàðàì access äà ñìÿòà ñ ïàðàìåòðè

    Â ïîñëåäíèòå äíè ñå áîðÿ ñ access 2007 êàòî ñâèíÿ ñ òèêâà è íå ìîãà äà íàïðàâÿ íàãëåä åëåìåíòàðíè íåùà.
    Íàé-îáùî êàçàíî, âúïðîñúò ìè å êàê äà íàêàðàì ïðîãðàìàòà äà ñìÿòà â report/form, âçåìàéêè äàííè îò table/query.


    Òàáëèöàòà ìè å íåùî îò òèïà:
    àà 10
    áá -20
    ââ 50
    ãã -4

    Öåëòà å â report èëè form äà ïîëó÷à íåùî êàòî:
    ïëþñîâå 60
    ìèíóñè -24
    îáùî 36

    Ìîãà äà íàïðàâÿ queries (ïëþñîâå, ìèíóñè è îáùî), êîèòî äà äàâàò îòäåëíèòå ñòîéíîñòè, íî êîãàòî îïèòàì äà îáåäèíÿ òðèòå èíôîðìàöèè â åäèí report èëè form, íå ìè ñå ïîëó÷àâà.
    Êàêâî ïðàâÿ:
    Â report/form ñëàãàì text box è â ïîëåòî data/control source îïèòâàì ðàçíè êîìáèíàöèè:
    =[ïëþñîâå]![ñóìà] - ðåçóëòàòúò å #Name?
    =sum([òàáëèöà]![êîëîíà2]) - ðåçóëòàòúò å #Error?
    Åñòåñòâåíî, àêî íàïèøà =3+2*4 ìè äàâà ðåçóëòàò 11.

    Äðóãî, êîåòî îïèòàõ å subreports/subforms, íî òîãàâà ñå ïîÿâÿâàò íåùà, êîèòî íå ãè èñêàì - ïëúçãà÷è, áóòîí÷åòà è äð.

  2. #2
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    Êàòî çà íà÷àëî, äàé äà âèäèì query-òî?
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  3. #3
    Registered User
    Join Date: Mar:2005
    Location: Ñîôèÿ
    Posts: 208
    Query-òî å "ñòàíäàðòíî", îò wizzard-a.
    Íåùî êàòî total=sum([table].[value]) çà îáùàòà ñóìà.
    Ñúùîòî, ñ äîáàâåíè êðèòåðèè çà value>0 è value<0 çà ïîëîæèòåëíèòå è îòðèöàòåëíèòå ñóìè ñà äðóãèòå äâå query-òà.

  4. #4
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    À íà report-à çà RecordSource êàêâî ñè çàäàë?
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  5. #5
    Registered User
    Join Date: Mar:2005
    Location: Ñîôèÿ
    Posts: 208
    Íå çíàåõ âúîáùå, ÷å ñúùåñòâóâà òàêîâà íåùî. Ñëåä êàòî çàäàäîõ query-òàòà êàòî RecordSource ïîñòèãíàõ òîâà, êîåòî èñêàõ. Âñå îùå èìà íÿêîè íåÿñíîòè ïî òåìàòà, íî ïîíå óñïÿõ äà çàõàïÿ. Áëàãîäàðÿ çà ïîìîùòà

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè