Solved

MS Access Values from One From Calculated on another

Posted on 2013-11-18
10
214 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 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
Industry Leaders: 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

685 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