Re: Help! I need some simple statistics

From: Rick B (Anonymous)
Date: 02/10/05 

Date: Thu, 10 Feb 2005 10:18:28 -0600

Yes, that is the whole point of a database.

You would need to build queries for each statistic you want. In the
queries, simply put in the criteria you want.

Unless you tell us the various items you want (and what criteria) we can't
really give you more details.

Rick B

"daff" <daff.1k8utn@news.officefrustration.com> wrote in message
news:daff.1k8utn@news.officefrustration.com...
>
> I'm making a database for storing information about casework that my
> colleagues do. I need to generate simple statistics on how many cases
> there were in specific time periods (e.g. previous month, quarter and
> year) and how many cases were completed by their deadlines, and what
> percentage were completed in time.
>
> How do I do this? Is it possible in Access? I'm tearing my hair out!
>
> I have DateReceived (The cases' start date) TargetDate and
> CompletionDate as fields in my table.
>
>
> --
> daff

Relevant Pages

  • Re: Stored Outlines
    ... Some queries have been developed which work ok against a development ... database where all objects have some representative statistics. ... Unfortunately, in the "bad" database, the stored outlines are not ...
    (comp.databases.oracle.server)
  • Stored Outlines
    ... I have some stored outlines that aren't being used and I can't figure ... Some queries have been developed which work ok against a development ... database where all objects have some representative statistics. ...
    (comp.databases.oracle.server)
  • Deleting indexes & statistics via T-SQL
    ... I wan't to delete the statistics & indexes from a database via queries. ... Because I don't know which statistics and indexes exists in the database I ... Does somebody know how I can see if the record from sysindexes is an index ...
    (microsoft.public.sqlserver.programming)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... I would focus on the queries behind the combo boxes. ... the Access 97 database, I wouldn't have thought any expressions would be ... When you select a customer and a job in the two combo boxes, ...
    (microsoft.public.access.conversion)