Re: Brak operatora w wyrażeniu kwerendy

Article View: pl.comp.bazy-danych.msaccess

Article #137803

Back to pl.comp.bazy-danych.msaccess Previous Next

#137803

From: Maciej Franciszkowski
Date: Mon, 24 Jan 2022 16:00

10 lines
1652 bytes

poniedziałek, 24 stycznia 2022 o 09:39:59 UTC+1 Karol Max napisał(a):
> DLookup("[UlicaNr]", "dbo_tb_Adresses", "[Instytucja] = Instytucja") 
> 
> Pomocy! 
> 
> Wyskakuje błąd: 
> Błąd składniowy (brak operatora) w wyrażeniu kwerendy '[Instytucja] = Firma ABC'

Spróbuj:
DLookup("[UlicaNr]", "dbo_tb_Adresses", "[Instytucja] = ' "& Instytucja &" ' ")

Technical Details

Message-ID: <bf6c8b99-f032-41f2-a6a8-9239e9c74750n@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!3.eu.feeder.erje.net!1.us.feeder.erje.net!feeder.erje.net!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail

References: <53ed9450-0b30-41d0-bba0-2c648c32e319n@googlegroups.com>

Show Full Headers

Complete Article Headers

X-Received: by 2002:a05:622a:15d6:: with SMTP id d22mr12972181qty.528.1643040022778;        Mon, 24 Jan 2022 08:00:22 -0800 (PST)
X-Received: by 2002:a05:6902:1145:: with SMTP id p5mr8355596ybu.274.1643040022418; Mon, 24 Jan 2022 08:00:22 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!3.eu.feeder.erje.net!1.us.feeder.erje.net!feeder.erje.net!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Mon, 24 Jan 2022 08:00:22 -0800 (PST)
In-Reply-To: <53ed9450-0b30-41d0-bba0-2c648c32e319n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=83.11.196.159; posting-account=MMDGXwoAAADfMWi5ThEatt5B2ixmi_hp
NNTP-Posting-Host: 83.11.196.159
References: <53ed9450-0b30-41d0-bba0-2c648c32e319n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <bf6c8b99-f032-41f2-a6a8-9239e9c74750n@googlegroups.com>
Subject: Re: Brak operatora w wyrażeniu kwerendy
From: Maciej Franciszkowski <macfrane@gmail.com>
Injection-Date: Mon, 24 Jan 2022 16:00:22 +0000
Lines: 12
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message