[AccessD] Basic Query Design

It is when you're using them to populate a datagrid.

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 1:48 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com