Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access Values from One From Calculated on another

Posted on 2013-11-18
10
Medium Priority
?
229 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
  • 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
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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 …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

879 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