Excel frequency function in Access

C

cursednomore

I designed a spreadsheet in Excel using the frequency function to count the
number of sales that fell between two sets of values in increments. Is there
a way to do this in Access? I would like to use Access for this in order to
be able to create additional reports. I was basically counting sales in $25
increments between $350 and $2000. Any help would be greatly appreciated.
 
D

David Lloyd

Below is one alternative to calculating frequencies. It creates grouping
intervals of $25, and constrains the query output to sales between $350 and
$2000.

SELECT Count(Frequency.Sales) AS CountOfSales, Int([Sales]/25)*25 & " - " &
(Int([Sales]/25)+1)*25 AS [GROUP]
FROM Frequency
WHERE (((Frequency.Sales)>=350 And (Frequency.Sales)<=2000))
GROUP BY Int([Sales]/25)*25 & " - " & (Int([Sales]/25)+1)*25,
Int([Sales]/25)*25
ORDER BY Int([Sales]/25)*25;

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


I designed a spreadsheet in Excel using the frequency function to count the
number of sales that fell between two sets of values in increments. Is there
a way to do this in Access? I would like to use Access for this in order to
be able to create additional reports. I was basically counting sales in $25
increments between $350 and $2000. Any help would be greatly appreciated.
 
M

Michel Walsh

Hi,

In addition to David's solution, you can also take a look at the Partition
function (in the help file) with its example.


Hoping it may help,
Vanderghast, Access MVP
 
Top