Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Issue with running total in an access form

Posted on 2013-10-28
6
Medium Priority
?
456 Views
Last Modified: 2013-10-30
Hi,
I have a seemingly simple issue with the attached form in access

currently the form "frm_qry_tbl_visa_imports" has a total text field that calculates the totals of "Amounts".

I am trying to make it so that it only does a running total of the records where "Assigned" is check as somebody checks them. So if none are checked, the total should be zero.

thanks,
Vinnie
PBJ-test-and-Trial.accdb
0
Comment
Question by:damixa
[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
  • 2
  • 2
6 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39606001
0
 
LVL 22

Accepted Solution

by:
Flyster earned 2000 total points
ID: 39606006
Use this in your Total Selected text box control source:

=Sum(IIf([Assigned]=-1,[amount],0))

In your Assigned checkbox On Click event enter this:

Me.Refresh

That should update the total as the boxes are checked.

Flyster
0
 

Author Comment

by:damixa
ID: 39606079
Thanks so much. Works like a charm

Vinnie
0
 

Author Comment

by:damixa
ID: 39606137
I've requested that this question be closed as follows:

Accepted answer: 0 points for damixa's comment #a39606079

for the following reason:

Thanks a ton. Works like a charm
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39606138
damixa,

you are requesting to close the Q with your post as the accepted answer???
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

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.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
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. …

604 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