Help! I need some simple statistics

D

daff

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.
 
R

Rick B

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
 
N

NetworkTrade

Date/Time span defined queries are so commonly needed that one would think
that by now Access would have these prompted by a Wizard in plain english -
but alas they are not....

In the Query-design view - you need to put an expression in the Criteria row
for the date field. And even the simplist expressions are a tough sled for
newbies....your will probably be something like: >01/01/2005 i.e for
anything after the new year
 
P

Pendragon

You can write one query for multiple dates by utilizing a prompt for user
input. For example, if you want all cases within a certain date range by
Target Date, put this in the criteria (anything in [] you can edit to
whatever you like - this is the text of the prompt to the user for data
input):
=[Enter start date] And <=[Enter end date]
Click to expand...

If you copy exactly this criteria to another field's criteria within the
same query, the user's single input for Start Date and End Date will filter
the records accordingly in BOTH fields.
 
Top