[AccessD] Basic Query Design

Charlotte,

Well, of course, now that you say that, it makes perfect sense.  Why
redo multiple "hierarchical" queries to generate recordsets in a
loop...when you can do one SHAPE query and get all the data at once?

Steve Erbach
Neenah, WI

On 2/10/06, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> 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