Article View: pl.comp.bazy-danych.msaccess
Article #137149Re: Access 2010 łączenie kilku kryteriów do kwerendy
From: MaciejF
Date: Sat, 30 Apr 2016 19:01
Date: Sat, 30 Apr 2016 19:01
19 lines
2306 bytes
2306 bytes
W Excelu zadziłąłą taka funkcja: (Przypominan ciąg końcowy: """A1"",""B1"",""C1""" 8 apostrofów na początku + & Replace(sCond, Chr(59), """""" & Chr(44) & """""") & <- 2x6 apostrofów + 8 apostrofów na koniec warunek sCond przed przekazaniem do SQLa: sCond = """""""" & Replace(sCond, Chr(59), """""" & Chr(44) & """""") & """""""" Dobrze policz ile apostrofów wstawiłeś! Pozdrawiam MF
Technical Details
Message-ID:
<2c83331b-ba90-4750-b399-7fa0437c2376@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!news.glorb.com!sq19no799184igc.0!news-out.google.com!uv8ni303igb.0!nntp.google.com!i5no698640ige.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mailReferences:
<571b871d$0$641$65785112@news.neostrada.pl> <073ae140-8104-4f0b-8178-a838692eda19@googlegroups.com> <5724847c$0$22828$65785112@news.neostrada.pl> <fdc4a38d-07f8-41f4-bb94-723d97a4c145@googlegroups.com> <fd443da0-eedc-4a0c-a73f-0db905d90224@googlegroups.com> <5724ddf1$0$658$65785112@news.neostrada.pl> <8aed9f36-9a23-43c1-b4a9-a6a820e54b3d@googlegroups.com> <eafa8aa8-8082-4adf-ab98-8f001100dcc3@googlegroups.com> <5724f365$0$22836$65785112@news.neostrada.pl> <4e19ace0-0be4-4e68-9b5a-3d7d0c34e3c4@googlegroups.com> <093a4234-c2b4-49a1-9080-56eac66a12bd@googlegroups.com>Show Full Headers
Complete Article Headers
X-Received: by 10.66.124.198 with SMTP id mk6mr16916588pab.12.1462042901992; Sat, 30 Apr 2016 12:01:41 -0700 (PDT) X-Received: by 10.50.150.5 with SMTP id ue5mr238106igb.5.1462042901955; Sat, 30 Apr 2016 12:01:41 -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!news.glorb.com!sq19no799184igc.0!news-out.google.com!uv8ni303igb.0!nntp.google.com!i5no698640ige.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: pl.comp.bazy-danych.msaccess Date: Sat, 30 Apr 2016 12:01:41 -0700 (PDT) In-Reply-To: <093a4234-c2b4-49a1-9080-56eac66a12bd@googlegroups.com> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=77.253.61.208; posting-account=kc7ZIQoAAAB5PkdJgxjq1dd8jnBK4MVp NNTP-Posting-Host: 77.253.61.208 References: <571b871d$0$641$65785112@news.neostrada.pl> <073ae140-8104-4f0b-8178-a838692eda19@googlegroups.com> <5724847c$0$22828$65785112@news.neostrada.pl> <fdc4a38d-07f8-41f4-bb94-723d97a4c145@googlegroups.com> <fd443da0-eedc-4a0c-a73f-0db905d90224@googlegroups.com> <5724ddf1$0$658$65785112@news.neostrada.pl> <8aed9f36-9a23-43c1-b4a9-a6a820e54b3d@googlegroups.com> <eafa8aa8-8082-4adf-ab98-8f001100dcc3@googlegroups.com> <5724f365$0$22836$65785112@news.neostrada.pl> <4e19ace0-0be4-4e68-9b5a-3d7d0c34e3c4@googlegroups.com> <093a4234-c2b4-49a1-9080-56eac66a12bd@googlegroups.com> User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <2c83331b-ba90-4750-b399-7fa0437c2376@googlegroups.com> Subject: Re: Access 2010 łączenie kilku kryteriów do kwerendy From: MaciejF <maciejfr@onet.pl> Injection-Date: Sat, 30 Apr 2016 19:01:41 +0000 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit