|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 18th, 2003, 01:44 PM
|
||||
|
||||
|
SELECT DISTINCT and COUNT
I'm trying to write a query for an access database to give me distinct dates letters were sent out and the number that were sent out that day, and I'm having some trouble. My SQL book gives the following example:
Code:
SELECT COUNT(DISTINCT DateSent) FROM Mailings COUNT(DISTINCT DateSent) To which access says syntax error. Can anybody help me out? Thanks!
|
|
#2
July 18th, 2003, 03:43 PM
|
|||
|
|||
|
Code:
select count(*) from (select distinct datesend from mailings)
|
|
#3
July 18th, 2003, 06:55 PM
|
||||
|
||||
|
swampboogie, i can't believe you slipped up, you are usually perfect
 Quote:
"number sent that day" --> number sent each date Code:
select DateSent, count(*)
from mailings
group
by DateSent
rudy http://r937.com/
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > SELECT DISTINCT and COUNT |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
