[AccessD] ...gurus only

LOL, I'll tell ya, if I learned anything about SQL in my years playing
with Access, it's that using plain old queries, such as what the wizard
does automatically for you is like riding a bike.  Using union queries
and subqueries is like riding a space shuttle.  You can go A LOT further
in it, though it's slightly more complex to operate! ;)

The key is to remember that queries are great for dealing with vertical
data (columns).  You can sum a column simply by saying Sum([SomeField]),
and it doesn't matter if there are a million records, it sums it off
that one line.  But if you need to Sum a Row, you have to build it
[SomeField]+[AnotherField]+[YetAnotherField].  This works, but if more
fields are added, it can be a pain, cause you have to adjust the
statements.  With a Union Query, you can take the horizontal, and make
it vertical...which, admittedly, if you add more fields, you still have
to change the union query (unless you build it on the fly), but it's
much cleaner, and easier to deal with.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William
Hindman
Sent: Friday, November 02, 2007 3:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] ...gurus only

...looks can be deceiving :)

William

----- Original Message ----- 
From: "Rocky Smolin at Beach Access Software" <rockysmolin at bchacc.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, November 02, 2007 3:37 PM
Subject: Re: [AccessD] ...gurus only


> This looks like an easy job for a bit of code.  And a real tough job
for
> queries.
>
> Rocky
>

The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.