Solved

dsum depend on checkbox

Posted on 2013-06-20
2
491 Views
Last Modified: 2013-06-20
attached sample.
i need to have txtsum value depend of checkbox (true.false)
means sum all checkbox only when true. (before update)
samplev4.accdb
0
Comment
Question by:drtopserv
  • 2
2 Comments
 

Accepted Solution

by:
drtopserv earned 0 total points
ID: 39264882
Well,thnx i have found the solution,
i should use checkbox afterupdate :
If Me.Dirty Then Me.Dirty = False
and use :
=Sum(IIf([chkbox]=True,[amount],0))
in the source control of the txtsum
0
 

Author Closing Comment

by:drtopserv
ID: 39264883
:}
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

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

773 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