Solved

MS Access Values from One From Calculated on another

Posted on 2013-11-18
10
216 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 30

Expert Comment

by:hnasr
ID: 39659365
No attachment!
0
 

Author Comment

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

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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 30

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 30

Accepted Solution

by:
hnasr earned 150 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 30

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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 …

739 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