Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS Access Values from One From Calculated on another

Posted on 2013-11-18
10
Medium Priority
?
225 Views
Last Modified: 2013-11-21
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.
0
Comment
Question by:deefel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 5
10 Comments
 
LVL 31

Expert Comment

by:hnasr
ID: 39659365
No attachment!
0
 

Author Comment

by:deefel
ID: 39660130
now has attachment.  thanks
US-example.xls
0
 
LVL 31

Expert Comment

by:hnasr
ID: 39660198
If this is in access then upload a sample database.
Explain steps to follow, and what to expect.
0
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:deefel
ID: 39660351
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
 
LVL 31

Expert Comment

by:hnasr
ID: 39661420
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
 

Author Comment

by:deefel
ID: 39661731
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
 
LVL 31

Accepted Solution

by:
hnasr earned 600 total points
ID: 39661797
Check and comment.
Example-3.mdb
0
 

Author Comment

by:deefel
ID: 39665101
thanks so much.  It appears to be working just fine.  thanks
0
 
LVL 31

Expert Comment

by:hnasr
ID: 39665242
Welcome!
0
 

Author Comment

by:deefel
ID: 39667015
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

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question