Article View: pl.comp.bazy-danych.msaccess
Article #137493Re: Typ obliczeniowy, wyświetlanie nazwy zamiast identyfikatora
From: minfo
Date: Mon, 10 Jul 2017 04:58
Date: Mon, 10 Jul 2017 04:58
16 lines
2108 bytes
2108 bytes
jeszcze poprawki: SQL1: SELECT Format$([data];"YYYY MMMM") AS RokMiesiac, Year(data), Month(data), dział, id, [nazwa projektu] FROM Projekty GROUP BY Format$([data];"YYYY MMMM"), id, [nazwa projektu] SQL2: SELECT ([Rok] & Chr(32) & [miesiąc]) AS RokMiesiac, [Rok], [Miesiac], dział, Sum(kwota brutto] AS Koszt_suma FROM [Koszty stałe] GROUP BY ([Rok] & Chr(32) & [miesiąc]), dział, Sum(kwota brutto] Dalej łączysz po Rok, Miesiac, dział. MF
Technical Details
Message-ID:
<8ad61db6-08fb-4cd4-92a4-1eeb25889031@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!goblin3!goblin2!goblin.stu.neva.ru!peer03.am4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!v31no1474220qtb.0!news-out.google.com!f200ni3892itc.0!nntp.google.com!188no1761708itx.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<5d54190f-1e5d-4e1b-88a6-91ad9aaed1a3@googlegroups.com> <8cd54a56-38d1-4e9f-832d-19dc34f10347@googlegroups.com> <dece1b92-e4b3-4786-9546-1e4839d66bc5@googlegroups.com> <71c591c9-494d-426f-be73-a6344fd4a69e@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.13.201.70 with SMTP id l67mr12245266ywd.164.1499662698372; Sun, 09 Jul 2017 21:58:18 -0700 (PDT) X-Received: by 10.36.34.209 with SMTP id o200mr380352ito.0.1499662698320; Sun, 09 Jul 2017 21:58:18 -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!goblin3!goblin2!goblin.stu.neva.ru!peer03.am4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!v31no1474220qtb.0!news-out.google.com!f200ni3892itc.0!nntp.google.com!188no1761708itx.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Sun, 9 Jul 2017 21:58:17 -0700 (PDT) In-Reply-To: <71c591c9-494d-426f-be73-a6344fd4a69e@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=213.241.94.194; posting-account=vYGi6woAAAA6NlWlzOm2dBNZ6sPJDKfx NNTP-Posting-Host: 213.241.94.194 References: <5d54190f-1e5d-4e1b-88a6-91ad9aaed1a3@googlegroups.com> <8cd54a56-38d1-4e9f-832d-19dc34f10347@googlegroups.com> <dece1b92-e4b3-4786-9546-1e4839d66bc5@googlegroups.com> <71c591c9-494d-426f-be73-a6344fd4a69e@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <8ad61db6-08fb-4cd4-92a4-1eeb25889031@googlegroups.com> Subject: Re: Typ obliczeniowy, wyświetlanie nazwy zamiast identyfikatora From: minfo@onet.pl Injection-Date: Mon, 10 Jul 2017 04:58:18 +0000 X-Received-Bytes: 1925 X-Received-Body-CRC: 1986777647 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit