PC Review


Reply
Thread Tools Rate Thread

Chart by Date

 
 
=?Utf-8?B?RGF2aWRH?=
Guest
Posts: n/a
 
      14th Sep 2006
I wish to create a chart, histogram, that shows the number of occurances in
each month of three unrelated events for which I have the dates. I've tried:

Group by - Date By Month: Format$(Date1,'mmmm yyyy')
Count - DateA: Date1
Count - DateB: Date2
Count - DateC: Date3

The SQL comes out as:
SELECT DISTINCTROW Format$(Client.DateOfReferral,'mmmm yyyy') AS [Date By
Month], Count(Date1) AS DateA, Count(Date2) AS DateB, Count(Date3) AS DateC
FROM Fred
GROUP BY Format$(Date1,'mmmm yyyy');


But the result is incorrect. How can I make the "Group by" be independent of
any of the data? Thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" roadsidetree Microsoft Excel Charting 17 12th May 2010 06:51 PM
Cannot Activate Chart Area in Chart. Chart Object Failed ahperez@gmail.com Microsoft Excel Programming 2 8th Aug 2006 02:38 AM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent Mike Saifie Microsoft Access Form Coding 1 9th Mar 2006 02:08 AM
pasting chart shows chart area, not the chart =?Utf-8?B?UGlyam8=?= Microsoft Powerpoint 3 13th Oct 2005 04:31 AM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Microsoft Excel Charting 2 22nd Jan 2005 04:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:27 PM.