Frequency Bands??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database that wish has several thousand nunbers in % format (10%,
12%, 55% etc etc). I wish to summarise the count of these into Bands 0-10%,
11-20% etc etc. In Excel I can use the Frequency Function in array form to do
this with ease. Can I do this in ACCESS or do I need to export to Excel?

Thanks
 
Peter said:
I have a database that wish has several thousand nunbers in % format (10%,
12%, 55% etc etc). I wish to summarise the count of these into Bands 0-10%,
11-20% etc etc. In Excel I can use the Frequency Function in array form to do
this with ease. Can I do this in ACCESS or do I need to export to Excel?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the Partition() function. See the Access VBA Help article
"Partition function" for more info. The values used in the Partition
function must be numbers, not strings.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQgr1l4echKqOuFEgEQKCxQCguQxCDV+l0LXW7vtB7IIyXTflc7AAnjk/
3g2CiOGpK9T7rOtBf0qvupPR
=pfLk
-----END PGP SIGNATURE-----
 
Back
Top