Results 1 to 4 of 4

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User marto96's Avatar
    Join Date: May:2008
    Location: Ñîôèÿ
    Posts: 2,211

    Ñúáèðàíå â Access

    Èìàì äà íàïðàâÿ ÁÄ íà Access çà ñêëàä çà åëåêòðîííè åëåìåíòè.
    Íàïðàâèõ òàáëèöèòå, íàïðàâèõ âðúçêèòå ìåæäó òÿõ, íàïðàâèõ ôîðìóëÿð çà ïðèåìàíå íà ïîðú÷êè è çàÿâêà çà èçâëè÷àíå íà ïîðú÷êè äî äàòà, âúâåäåíà îò êëèåíòà, íî ïîñëåäíîòî óñëîâèå - äà ñå èç÷èñëè îáùàòà öåíà íà íàïðàâåíèòå ïîðú÷êè ïî àðòèêóëè, ìå çàòðóäíÿâà. Òîåñò, òðÿáâà ìè îùå åäíà çàÿâêà, êúäåòî ñðåùó èìåòî íà àðòèêóëà äà ïèøå îáùàòà öåíà îò âñè÷êè ïîðú÷êè (òîåñò, àêî åäèí ðåçèñòîð å ïðîäàäåí 2 ïúòè, â äâå ðàçëè÷íè ïîðú÷êè, çà ïî 0,20ëâ, òî â çàÿâêàòà äà èçëèçà "Ðåçèñòîð" - 0,40ëâ.). Ïðîáëåìúò å, ÷å àêî åäèí àðòóêóë å ïîðú÷àí ïîâå÷å îò âåäíúæ, òîé èçëèçà â çàÿâêàòà êàòî îòäåëåí ïðîäóêò, à íà ìåí ìè òðÿáâà äà èçëèçà ñàìî èìåòî íà àðòèêóëà è îáùàòà öåíà îò âñè÷êè ïîðú÷êè.

    Ïðèêà÷âàì áàçàòà ñ äàííè, áëàãîäàðÿ íà îòçîâàëèòå ñå!

    Áàçà äàííè
    ASRock B450M Pro4 / 5700X@4.5GHz / MSI RX 6600 XT Mech 2X / be quiet! Dark Rock 4 / 2x16GB FlareX 3200MHz CL16 / FSP Hydro G Pro 1000W / Samsung Odyssey G5 S27AG50

  2. #2
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    Íÿìàì Àêñåñ, íî òîâà êîåòî òè òðÿáâà å íåùî òàêîâà:
    Code:
    select sum(èìåòî_íà_êîëîíàòà_ñ_ïàðèòå)
    from òàáëèöàòà_ñ_ïàðèòå
    group by êîëîíàòà_â_êîÿòî_ïèøå_êàêâî_å_ïðîäàäåíî
    Åñòåñòâåíî, àêî êîëîíàòà ïî êîÿòî ãðóïèðàø å ïðîñòî èìåòî íà åëåìåíòà, à íå ID... ìè ùå å ãàäíî è íàé-âåðîÿòíî ãðåøíî.
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  3. #3
    Banned all's Avatar
    Join Date: Feb:2003
    Location: Sofia
    Posts: 6,980
    Â çàÿâêàòà èìà åäíî "Group By"
    Â ïîëåòî çà ïðîäàæíàòà öåíà - ñëîæè Group by sum.

  4. #4
    Registered User marto96's Avatar
    Join Date: May:2008
    Location: Ñîôèÿ
    Posts: 2,211
    Êîëåãè, íÿìàòå ñè ïðåäñòàâà êîëêî ñúì âè áëàãîäàðåí
    ASRock B450M Pro4 / 5700X@4.5GHz / MSI RX 6600 XT Mech 2X / be quiet! Dark Rock 4 / 2x16GB FlareX 3200MHz CL16 / FSP Hydro G Pro 1000W / Samsung Odyssey G5 S27AG50

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