🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.databases.ms-access
Article #344

Need help with dates in Cross-Tab queries

#344
From: Avi
Date: Fri, 09 Jul 1999 00:00
41 lines
2304 bytes
--------------E025448D9C668D1399A735E0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,
I'm using a Cross-Tab querie for a sort of a calandar for several people
(each one have a row, the columns are dates).
The question is: how can I create  a querie for a range of dates (like:
from 1/2/99 to 1/3/99), and get all the dates in the range, without
having each and every one of them in a table?
A second question: How can I make the Cross-Tab querie display dates
that have nothing in them for any of the people?

Please replay via E-Mail to: Machness@surfree.net.il

Thanks,
Avi


--------------E025448D9C668D1399A735E0
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<HTML>
Hi,
<BR>I'm using a Cross-Tab querie for a sort of a calandar for several people
(each one have a row, the columns are dates).
<BR>The question is: how can I create&nbsp; a querie for a range of dates
(like: from 1/2/99 to 1/3/99), and get all the dates in the range, without
having each and every one of them in a table?
<BR>A second question: How can I make the Cross-Tab querie display dates
that have nothing in them for any of the people?

<P>Please replay via E-Mail to: <A HREF="mailto:machness@surfree.net.il">Machness@surfree.net.il</A>

<P>Thanks,
<BR>Avi
<BR>&nbsp;</HTML>

--------------E025448D9C668D1399A735E0--
Technical Details
Message-ID: <37857FC9.6FAB3EC1@surfree.net.il>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 111a5a,22e209564070fedf,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,22e209564070fedf,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f8db2,22e209564070fedf,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 10bb27,22e209564070fedf,start
X-Google-Attributes: gid10bb27,public
From: Avi <Machness@surfree.net.il>
Subject: Need help with dates in Cross-Tab queries
Date: 1999/07/09
Message-ID: <37857FC9.6FAB3EC1@surfree.net.il>
X-Deja-AN: 499856275
X-NNTP-Posting-Host: 212.3.197.51
Content-Type: multipart/alternative; boundary="------------E025448D9C668D1399A735E0"
X-Trace: 11 Jul 1999 23:26:53 +0200, 212.3.197.51
MIME-Version: 1.0
Reply-To: Machness@surfree.net.il
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,it.comp.database.access,microsoft.public.access.queries