Article View: pl.comp.bazy-danych.msaccess
Article #137521Re: Wartości z jednej kolumny tabeli wielu rekordów
From: minfo
Date: Fri, 25 Aug 2017 15:30
Date: Fri, 25 Aug 2017 15:30
16 lines
1921 bytes
1921 bytes
>
> Dziękuję za wyrozumiałość
SELECT tbFilie.tPaIDFilii, tbFilie.tPaNazwa, tbFilie.tPaMiejscowosc, tbTelefon.tTelNumer,
DSumText("tTelNumer","tbTelefon","tPaIDFilii=" & [tPaIDFilii],";"]) AS qTel, tbTelefon.tTelDFil
FROM tbFilie LEFT JOIN tbTelefon ON tbFilie.tPaIDFilii = tbTelefon.tTelDFil;
Spróbuj czy mam dobre przypuszczenie odnośnie sposobu w jaki podajesz parametry sField i sTable do funkcji KN.
Pozdrawiam
MF
Technical Details
Message-ID:
<8b10de6e-d436-4639-87a7-45782efa04bb@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!news.nask.pl!news.nask.org.pl!news.unit0.net!peer03.am4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!e2no459412qta.1!news-out.google.com!a26ni386qta.0!nntp.google.com!v29no459236qtv.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<0ffce41a-81c2-443c-a1cc-8d12b7c848ba@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.237.42.230 with SMTP id t93mr317727qtd.36.1503675018684; Fri, 25 Aug 2017 08:30:18 -0700 (PDT) X-Received: by 10.31.153.196 with SMTP id b187mr104960vke.14.1503675018651; Fri, 25 Aug 2017 08:30: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!news.nask.pl!news.nask.org.pl!news.unit0.net!peer03.am4!peer.am4.highwinds-media.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!e2no459412qta.1!news-out.google.com!a26ni386qta.0!nntp.google.com!v29no459236qtv.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Fri, 25 Aug 2017 08:30:18 -0700 (PDT) In-Reply-To: <0ffce41a-81c2-443c-a1cc-8d12b7c848ba@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=79.163.143.42; posting-account=vYGi6woAAAA6NlWlzOm2dBNZ6sPJDKfx NNTP-Posting-Host: 79.163.143.42 References: <0ffce41a-81c2-443c-a1cc-8d12b7c848ba@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <8b10de6e-d436-4639-87a7-45782efa04bb@googlegroups.com> Subject: Re: Wartości z jednej kolumny tabeli wielu rekordów From: minfo@onet.pl Injection-Date: Fri, 25 Aug 2017 15:30:18 +0000 X-Received-Bytes: 1704 X-Received-Body-CRC: 617339703 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit