RE: Query formulation question

2003-04-05 Thread Don Read
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

RE: Query formulation question

2003-04-04 Thread Christensen, Dave
ECTED] 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: [

RE: Query formulation question

2003-04-04 Thread Michael Shulman
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 quest