Calculating Percentage within Date Range

[LiseD]

I am trying to generate a report from a query that pulls data to show the
following:

- Greater than 300
- Within a certain date range

And am trying to calculate the percentage from that entire data that are
greater than 300 for that particular date range that I have selected.

How do I go about doing this? Is this built in the Reports or the Query?

Thank you.

 

[Jeff Boyce]

Percentage is calculated with a numerator and a denominator. It sounds like
you want "300" for the numerator.

What do you want to use as the denominator?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[LiseD]

What I am trying to do is this:

- The records in a particular field can range anywhere from 190 to 500.
- I want to retrieve all records that are 300 or greater
- AND calculate the percentage of records/individuals that are 300 or
greater of all the fields within a particular date range in a report.

When I run the query, I have a parameter that lets me enter the beginning
and end date and pulls all the records that are 300 or greater within that
date range, but they also want to know the percentage of these records that
are 300 or greater compared to all the other records wtihin that date range.

Hope that makes sense.

 

[Jeff Boyce]

I suspect you mean that the VALUES in a particular field can range between
190 and 500. If so, then it sounds like you would use the total number of
records in the date range as the denominator, and the count of records with
a value of 300 or more as the numerator. Is that a correct statement?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[LiseD]

Yes that is correct

I suspect you mean that the VALUES in a particular field can range between
190 and 500. If so, then it sounds like you would use the total number of
records in the date range as the denominator, and the count of records with
a value of 300 or more as the numerator. Is that a correct statement?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jeff Boyce]

So you need to count the number of records that meet your selection
criteria, and count the number of records. One way to do this is to use the
DCount() function (twice) in a query that then does the division.

Regards

Jeff Boyce
Microsoft Office/Access MVP