MS Access Values from One From Calculated on another

Using MS 2007 ~ I have a form that have some fields for Units, I would like for the user to be able select a range of the Units and have the sum of the range of units sold populate in another location on the form (see attached).  I need to be able to let the user to enter the fields they need and have the total sum of units populate base on the values of the units fields they select.
deefelAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
hnasrConnect With a Mentor Commented:
Check and comment.
Example-3.mdb
0
 
hnasrCommented:
No attachment!
0
 
deefelAuthor Commented:
now has attachment.  thanks
US-example.xls
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
hnasrCommented:
If this is in access then upload a sample database.
Explain steps to follow, and what to expect.
0
 
deefelAuthor Commented:
need user to be able to select a unit field between us1-1 to us9-9 and have the Total units sold value for the select fields populate the total units sold field for either PL1, PL2 or PL3.
Example.mdb
0
 
hnasrCommented:
Try this:

You did a little effort in setting field names and control sources.

Modified control names to allow for automatic assignment of values.
Did first controls in yellow, then modified all, although this task should be yours.
Good luck.
Example-2.mdb
0
 
deefelAuthor Commented:
you'll right about the names ~ thanks so much.  It appears to be working correctly ~ what I need it to do is give me the sum of the units sold vs the sum of the gsar.  How would I change out have the gsar accumulation and replace it with the sum of the units sold? (see attached example)
data-example.xlsx
0
 
deefelAuthor Commented:
thanks so much.  It appears to be working just fine.  thanks
0
 
hnasrCommented:
Welcome!
0
 
deefelAuthor Commented:
Could I please get additional help on the above subject.  I changed a few names on the form and attempted to change them in the code also.  I am now getting an error message (see attached) when I try to select for PL2 and PL3.  Database attached.
Book11.xlsx
Example-3b.zip
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.