invisible summation index

[vjp2.at]

I need to roundup by each subindex and then sum those.

So I have data that has i and j and I have just been counting the
number under j then dividing by a constant.

Now I need to count by i, divide by a constant, round up then sum by j


- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

 

[Jeff Boyce]

We aren't there. We can't see your data. We can't even tell if this is a
Microsoft Access question (this is a Microsoft Access newsgroup).

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

I need to roundup by each subindex and then sum those.

I am not familiar with the turm "subindex" within Access. And I've used Access
quite a bit.

So I have data that has i and j and I have just been counting the
number under j then dividing by a constant.

We have no way to know what you mean by "has i and j and counting the number
under j".

Now I need to count by i, divide by a constant, round up then sum by j

Please explain the context, the structure of your table or tables, and perhaps
an example.

 

[vjp2.at]

Ok, we used to calculate the count of all records in a region and
divide it by twenty. {SELECT COUNT(X)/20 AS Y, REGION GROUP BY REGION}
Now they want to divide each subregion's
(tract's) count by five, roundup() then add all the subregions up.

Select sum(roundup(count(x)/20)) as y, region, tract group by region??





- = -
Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus, BioStrategist
http://www.facebook.com/vasjpan2
---{Nothing herein constitutes advice. Everything fully disclaimed.}---
[Homeland Security means private firearms not lazy obstructive guards]
[Urb sprawl confounds terror] [Remorse begets zeal] [Windows is for Bimbos]

 

[Jeff Boyce]

Have you tried looking in Access HELP for the functions?

I recall that Roundup() is an Excel function, but does Access have one, too?

(by the way, if the "divide by" is likely to change again, consider using a
variable or a prompt so you don't have to keep 'maintaining' the code...)

Regards

Jeff Boyce
Microsoft Office/Access MVP