[AccessD] Basic Query Design

Charlotte,

Right you are!  I used them for a fancy report in an ASP project I did
last year.  Very interesting capability.  Hard to tell whether it's
worth the effort versus multiple queries to form those mutliple
recordsets.

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
www.swerbach.com
Security Page: www.swerbach.com/security
Blog:  http://TheTownCrank.blogspot.com


On 2/9/06, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> LOL Try the SQL for shaped recordsets sometime if you want to cause
> headaches!  ;o>
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach
> Sent: Thursday, February 09, 2006 7:36 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Basic Query Design
>
>
> Stuart,
>
> Hah!  The guy that came up with it is a professor in the Computer
> Science Dept. at UW-Parkside in Kenosha, WI...right in my neck of the
> woods.  After showing this method and explaining how it's derived in
> detail, he wrote, "Imagine presenting this to undergrads who have just a
> lecture or two of SQL under their belts.  You DO get the chance to talk
> about scoping of aliases..."
>
> Steve Erbach
> Scientific Marketing
> Neenah, WI
> http://TheTownCrank.blogspot.com