Re: FLASH: OT: Access SQL question

[james]

Try doing a SUM(y) and group by




--- Helen Triolo <

designeri-technica [dot] com

> wrote:

> Sorry for the OT, though it's tangentially related

> (query for an asp

> called by Flash).  If I have two fields x and y, and

> there are multiple

> values of y for every value of x, what's the right

> Access query to get

> the count of y's for each x?  I tried 

> 


__________________________________________________

Do You Yahoo!?

Get Yahoo! Mail - Free email you can access from anywhere!

http://mail.yahoo.com/


flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

     flashforward2000 and the Flash(tm) Film Festival

 July 24-26, 2000, NEW YORK CITY, Hammerstein Ballroom

                  www.flashforward2000.com

   Produced by United Digital Artists and lynda.com

 Sponsored by Macromedia, Adobe Systems, Fusion, Inc, AtomFilms,

           shockwave.com and Electric Rain.

 1.877.4.FLASH.4  or (1.805.640.6679 outside the US and Canada)

 Register before June 30 and save $200!!-- www.flashforward2000.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com