J
JustALittleHelp
(Intermediate Access knowledge)
I am trying to build a form that will allow users to: 1) select a group of
records; 2) enter an outside number in the form; 3) that number then
calculates a new number based on preassigned 'proportions'.
for example:
Region X (selected group of records) - Enter Cap==> [ 15 ]
Preassigned
Group #ppl %Ttl New #ppl New % of Ttl
#ppl
A 3 30 (=15*30%)
=15/(15*30%)
B 2 20 (=15*20%)
=15/(15*20%)
C 2 20 (=15*20%)
=15/(15*20%)
D 3 30 (=15*30%)
=15/(=15*20%)
--- ----- ---
------
TOTALS 10 100% 15 100%
I've got the option to select the group down. I need help with the
onscreen/form calculation of the right 3 columns. I'm guessing further
grouping, but I think I've hit my wall today and possibly tomorrow. ;-p
I am trying to build a form that will allow users to: 1) select a group of
records; 2) enter an outside number in the form; 3) that number then
calculates a new number based on preassigned 'proportions'.
for example:
Region X (selected group of records) - Enter Cap==> [ 15 ]
Preassigned
Group #ppl %Ttl New #ppl New % of Ttl
#ppl
A 3 30 (=15*30%)
=15/(15*30%)
B 2 20 (=15*20%)
=15/(15*20%)
C 2 20 (=15*20%)
=15/(15*20%)
D 3 30 (=15*30%)
=15/(=15*20%)
--- ----- ---
------
TOTALS 10 100% 15 100%
I've got the option to select the group down. I need help with the
onscreen/form calculation of the right 3 columns. I'm guessing further
grouping, but I think I've hit my wall today and possibly tomorrow. ;-p