Article View: pl.comp.bazy-danych.msaccess
Article #137498Re: Typ obliczeniowy, wyświetlanie nazwy zamiast identyfikatora
From: minfo
Date: Sun, 09 Jul 2017 14:17
Date: Sun, 09 Jul 2017 14:17
16 lines
2022 bytes
2022 bytes
Czyli nie wiesz jak zacząć.
Napisz sobie kwerendy.
SQL1:
SELECT Format$([data];"YYYY MMMM") AS RokMiesiac, id, [nazwa projektu] FROM Projekty
GROUP BY Format$([data];"YYYY MMMM"), id, [nazwa projektu]
SQL2:
SELECT ("2017" & Chr(32) & [miesiąc]) AS RokMiesiac, dział, Sum(kwota brutto] AS Koszt_suma FROM [Koszty stałe]
GROUP BY ("2017" & Chr(32) & [miesiąc]), dział, Sum(kwota brutto]
Potem 3 zapytanie łaczące w odpowiedni sposób 1 i 2.
to na początek.
Technical Details
Message-ID:
<dece1b92-e4b3-4786-9546-1e4839d66bc5@googlegroups.com>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin.stu.neva.ru!weretis.net!feeder6.news.weretis.net!feeder.erje.net!2.us.feeder.erje.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!v31no1298660qtb.0!news-out.google.com!s132ni1729itb.0!nntp.google.com!188no1550330itx.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<5d54190f-1e5d-4e1b-88a6-91ad9aaed1a3@googlegroups.com> <8cd54a56-38d1-4e9f-832d-19dc34f10347@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.176.1.208 with SMTP id 74mr7826509ual.9.1499609871725; Sun, 09 Jul 2017 07:17:51 -0700 (PDT) X-Received: by 10.36.80.193 with SMTP id m184mr272317itb.6.1499609871659; Sun, 09 Jul 2017 07:17:51 -0700 (PDT) Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!newsfeed2.atman.pl!newsfeed.atman.pl!goblin2!goblin.stu.neva.ru!weretis.net!feeder6.news.weretis.net!feeder.erje.net!2.us.feeder.erje.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!v31no1298660qtb.0!news-out.google.com!s132ni1729itb.0!nntp.google.com!188no1550330itx.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Sun, 9 Jul 2017 07:17:50 -0700 (PDT) In-Reply-To: <8cd54a56-38d1-4e9f-832d-19dc34f10347@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=79.163.140.123; posting-account=vYGi6woAAAA6NlWlzOm2dBNZ6sPJDKfx NNTP-Posting-Host: 79.163.140.123 References: <5d54190f-1e5d-4e1b-88a6-91ad9aaed1a3@googlegroups.com> <8cd54a56-38d1-4e9f-832d-19dc34f10347@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <dece1b92-e4b3-4786-9546-1e4839d66bc5@googlegroups.com> Subject: Re: Typ obliczeniowy, wyświetlanie nazwy zamiast identyfikatora From: minfo@onet.pl Injection-Date: Sun, 09 Jul 2017 14:17:51 +0000 Lines: 18 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit