Liczenie dni

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

Article #137682

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

#137682

From: k1618740
Date: Wed, 19 Feb 2020 07:41

8 lines
1385 bytes

Cześć
Potrzebuję, aby baza zwracała dni na zasadzie:
Od jutra do 40dni wstecz, lecz aby nie były zwracane weekendy.
Chciałbym wrzucić to do kwerendy w pole kryteria.
Stworzyłem jak poniżej, lecz tutaj niestety liczy wszystkie dni.
Da się coś takiego?

<=Date()+"1" And >Date()-"40"

Technical Details

Message-ID: <f254d6c6-73a0-489b-8b47-6fd51ac0b521@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!feeder.erje.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Received: by 2002:a37:4dc4:: with SMTP id a187mr22780971qkb.436.1582098071859;        Tue, 18 Feb 2020 23:41:11 -0800 (PST)
X-Received: by 2002:ad4:580b:: with SMTP id dd11mr19451702qvb.242.1582098071693; Tue, 18 Feb 2020 23:41:11 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!feeder.erje.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Tue, 18 Feb 2020 23:41:11 -0800 (PST)
Complaints-To: groups-abuse@google.com
Injection-Info: google-groups.googlegroups.com; posting-host=192.109.140.174; posting-account=kX461AoAAAArt3boB3YcqZQl0hBbziZO
NNTP-Posting-Host: 192.109.140.174
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <f254d6c6-73a0-489b-8b47-6fd51ac0b521@googlegroups.com>
Subject: Liczenie dni
From: k1618740@gmail.com
Injection-Date: Wed, 19 Feb 2020 07:41:11 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit