Flasher Archive
[Previous] [Next] - [Index] [Thread Index] - [Previous in Thread] [Next in Thread]
| Subject: | FLASH: OT: Access SQL question |
| From: | Helen Triolo |
| Date: | Fri, 23 Jun 2000 01:15:57 +0100 |
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
select x, count(distinct y)
from table
group by x
but Access won't run this query -- gives me an error. Anyone know?
Thanks,
Helen
----------------------------------------
helen triolo � http://i-technica.com
designer
i-technica [dot] com � 301-424-6037----------------------------------------
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 help
chinwag [dot] com
Replies
Re: FLASH: OT: Access SQL question, Helen Triolo
Re: FLASH: OT: Access SQL question, Cheri Harder
[Previous] [Next] - [Index] [Thread Index] - [Next in Thread] [Previous in Thread]
