Hello Bill,
Just want to say Hi, and I was wondering how everything is going. If
anything is unclear, please let me know. Have a great day.
Thanks & Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! -
www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| X-Tomcat-ID: 143152437
| References: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: (e-mail address removed) (Peter Yang [MSFT])
| Organization: Microsoft
| Date: Fri, 12 Nov 2004 06:47:41 GMT
| Subject: RE: Charts - Select Year Range
| X-Tomcat-NG: microsoft.public.access.reports
| Message-ID: <
[email protected]>
| Newsgroups: microsoft.public.access.reports
| Lines: 74
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.reports:150790
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Hello Bill,
|
| I think you may want to add "(qryname.[Field2])=2004" in the query:
|
| TRANSFORM Count(qryname.Field1) AS [The Value]
| SELECT qryname.[Field2], qryname.Field2, Count(qryname.Field1) AS [Total
Of
| Field1]
| FROM qryname
| WHERE (((qryname.[Field2])=2003 or (qryname.[Field2])=2004 ) AND
| ((qryname.[Field4]) Not Like "car"))
| GROUP BY qryname.[Field2], qryname.Field3, qryname.[Filed4]
| PIVOT qryname.[Field5];
|
| Hope this helps.
|
| Best Regards,
|
| Peter Yang
| MCSE2000/2003, MCSA, MCDBA
| Microsoft Online Partner Support
|
| Get Secure! -
www.microsoft.com/security
|
| =====================================================
| When responding to posts, please "Reply to Group" via
| your newsreader so that others may learn and benefit
| from your issue.
| =====================================================
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
| --------------------
| | NNTP-Posting-Date: Thu, 11 Nov 2004 18:20:54 -0600
| | From: "Bill" <
[email protected]>
| | Newsgroups: microsoft.public.access.reports
| | Subject: Charts - Select Year Range
| | Date: Thu, 11 Nov 2004 19:20:51 -0500
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| | Message-ID: <
[email protected]>
| | Lines: 19
| | NNTP-Posting-Host: 69.193.7.158
| | X-Trace:
|
sv3-V2s/s27A6+oBIILgo5aGgDGYgpY3av4Vz2/jxNhl7UFgUoe9dhdf56WT0yvgLld36MG9fAUf
|
Mrc9hG2!4liqFlNtPgBqnXVcVBcrRbi51ihdW64C9Uzqe/deO2t1V8kW7JZunAjSvZRNlAlQqYPv
| pZU=
| | X-Complaints-To: (e-mail address removed)
| | X-DMCA-Complaints-To: (e-mail address removed)
| | X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
| | X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
| complaint properly
| | X-Postfilter: 1.3.20
| | Path:
|
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwi
|
x.com!newsfeed.cwix.com!border1.nntp.dca.giganews.com!nntp.giganews.com!loca
|
l1.nntp.dca.giganews.com!nntp.rogers.com!news.rogers.com.POSTED!not-for-mail
| | Xref: cpmsftngxa10.phx.gbl microsoft.public.access.reports:150758
| | X-Tomcat-NG: microsoft.public.access.reports
| |
| | Hi,
| |
| | I'm having a problem to select Year Range like from 2003 to 2004. I
try
| to
| | open the charts and it gives me the report in 2003 only because it show
| as:
| |
| | TRANSFORM Count(qryname.Field1) AS [The Value]
| | SELECT qryname.[Field2], qryname.Field2, Count(qryname.Field1) AS
[Total
| Of
| | Field1]
| | FROM qryname
| | WHERE (((qryname.[Field2])=2003) AND ((qryname.[Field4]) Not Like
"car"))
| | GROUP BY qryname.[Field2], qryname.Field3, qryname.[Filed4]
| | PIVOT qryname.[Field5];
| |
| | I would need help how to put Year Range form 2003 to 2004 instead of
one
| | 2003 only. Your help would be much appreciated.
| |
| | Thanks
| |
| |
| |
|
|
