year-to-date count for multiple years
Hello. I am hoping someone out there can help me. I track homicide
data and run reports for police administrators when they request it. I
have data from 2005 and 2006. I want to be able to give them the count
of homicides by district to-date. So, today's report would give a
count of 2005 homicides by district from 1/1/05 to 8/28/05 and also of
2006 homicides by district from 1/1/06 to 8/28/06. I know I could run
separate queries and enter the current date each time, but I would like
to have a query that I can just run and it calculates it by the current
date automatically. Is there any way to do this? Thank you for your
help in advance!
.
Relevant Pages
- HTMLText Interpretation generates runtime error
... I am using Crystal Reports integrated with MicroSoft Visual Studio.Net ... Database is MS Access 2003 and OS is ... The request could not be submitted for background processing. ... Exception Details: CrystalDecisions.CrystalReports.Engine.InternalException: ...
(microsoft.public.vb.crystal) - Please Help Me: HTMLText Interpretation causes lots of Problems to me.
... I am using Crystal Reports integrated with MicroSoft Visual Studio.Net ... Database is MS Access 2003 and OS is ... The request could not be submitted for background processing. ... Exception Details: CrystalDecisions.CrystalReports.Engine.InternalException: ...
(microsoft.public.vb.crystal) - Re: Word 2003 and DotNet
... >Hi James, ... >reports in word programmatically directly in a Word ... If the application is impersonating via ... >IUSR_MACHINENAME) or the authenticated request user. ...
(microsoft.public.dotnet.general) - Re: Word 2003 and DotNet
... You could give enough priveleges to asp.net account though I don't recommend ... reports in word programmatically directly in a Word document. ... If the application is impersonating via <identity ... IUSR_MACHINENAME) or the authenticated request user. ...
(microsoft.public.dotnet.general) - ANN: ISMRR: Request & Response - Update Notice - 1.0.1.47
... Request & Response Tracking that offers several new features as well as ... -Added option in SQL Repository to save to Login SQL in User Settings ... -Added Grid Font to Settings ... -Fixed problem with locations not resetting on reports on server change ...
(borland.public.delphi.thirdpartytools.general) |
|
