🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: A'97 - Raport dla wybranych rekordów z formularza ???

#128
From: Janusz Baranowski
Date: Tue, 10 Nov 1998 22:49
12 lines
1277 bytes
Witam,

moja propozycja to zapisanie warunku w postaci:

"[Data] > #" & Format$(Me!DataPoczatkowa,"mm/dd/yyyy") & "# AND
 [Data wpisu] < #" & Format$(Me!DataKoncowa,"mm/dd/yyyy") & "#"

W ten sposob mamy zawartosc pol formularza w #...#, a daty formatujemy wedlug
normy amerykanskiej (miesiac,dzien,rok) obowiazujacej w zapytaniach SQL.


Janusz Baranowski
Technical Details
Message-ID: <3648C3DE.5F530A1D@peugeot.com.pl>
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.nask.pl!orion.cst.tpsa.pl!news.tpnet.pl!not-for-mail
References: <727m5b$o9l$2@korweta.task.gda.pl> <3647ee48.0@news.vogel.pl>

Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!mat.uni.torun.pl!news.nask.pl!orion.cst.tpsa.pl!news.tpnet.pl!not-for-mail
Message-ID: <3648C3DE.5F530A1D@peugeot.com.pl>
From: Janusz Baranowski <januszb@sec.polbox.pl>
Reply-To: januszb@peugeot.com.pl
X-Mailer: Mozilla 4.05 [en] (X11; I; Linux 2.0.34 i586)
MIME-Version: 1.0
Newsgroups: pl.comp.bazy-danych.msaccess
Subject: Re: A'97 -  Raport dla wybranych rekordów z
 formularza ???
References: <727m5b$o9l$2@korweta.task.gda.pl> <3647ee48.0@news.vogel.pl>
Lines: 13
Date: Tue, 10 Nov 1998 22:49:52 GMT
NNTP-Posting-Host: 195.117.80.70
X-Complaints-To: abuse@tpsa.pl
X-Trace: news.tpnet.pl 910738192 195.117.80.70 (Tue, 10 Nov 1998 23:49:52 MET DST)
NNTP-Posting-Date: Tue, 10 Nov 1998 23:49:52 MET DST
Organization: TPNET - http://www.tpnet.pl
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit