On 04-Apr-2003 [EMAIL PROTECTED] wrote:
Hi there,
I have some experience with SQL, but I'm drawing a blank on this one. I
have a table with these fields:
Location
Unit
StartDate
StopDate
I want to construct a SELECT statement to get to a report that looks
something like this:
This is quite complicated with SQL. However, Microsoft Excel has excellent
tools for creating crosstabs exactly like this.
-ms
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 9:56 AM
To: [EMAIL PROTECTED]
Subject: Query formulation
]
Subject: RE: Query formulation question
This is quite complicated with SQL. However, Microsoft Excel has excellent
tools for creating crosstabs exactly like this.
-ms
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 9:56 AM
To: [EMAIL