Article View: comp.databases.ms-access
Article #344Need help with dates in Cross-Tab queries
From: Avi
Date: Fri, 09 Jul 1999 00:00
Date: Fri, 09 Jul 1999 00:00
41 lines
2304 bytes
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 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> </HTML> --------------E025448D9C668D1399A735E0--
Technical Details
Message-ID:
<37857FC9.6FAB3EC1@surfree.net.il>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow 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