On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Course Of The Month
11 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Add total of precentages complete
Posted on 2012-12-26
I have a unbound field called precentages. Which I got help from a expertm named flyster. (Thank you). Cant seem to find where he put the code.
I look in the properties of the unbound field.
I looked in the form maybe on current.
I clicked on view code. and it didnt showed up.
what i am trying to do is total up the percentage done for each unit based on check marks. each check mark is worth a certain percentage i need to change that. But I cant seem to find the code.
I look in the properties of the unbound field.
I looked in the form maybe on current.
I clicked on view code. and it didnt showed up.
what i am trying to do is total up the percentage done for each unit based on check marks. each check mark is worth a certain percentage i need to change that. But I cant seem to find the code.
[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
4 Comments
here is the database with th unbound field percentages..the record source does not have a where clause
bingo3.accdb
bingo3.accdb
Active 2 days ago
The code is the query used as the record source for the form. And Percentages is one field of the query.
the last portion of the query:
...
[OutDuction])/17),"00.0%")
The query refers to 17 but you have 18 check boxes.
Open form in design mode. From objects drop down list select form. Then Select Data Tab.
The query is set as the Record Source property.
the last portion of the query:
...
[OutDuction])/17),"00.0%")
The query refers to 17 but you have 18 check boxes.
Open form in design mode. From objects drop down list select form. Then Select Data Tab.
The query is set as the Record Source property.
Active 6 days ago
<I have a unbound field called precentages. >
The Percentages field in the form is bound...
It is bound to a field called "percentages"
Percentages is a field in the form's recordsource/query, ...so there is no "Code":
Percentages: Format(Abs(([tblTempleFuel
Whenever you get a solution from an expert, please ask any questions at that time, if you are confused about something.
;-)
JeffCoachman
The Percentages field in the form is bound...
It is bound to a field called "percentages"
Percentages is a field in the form's recordsource/query, ...so there is no "Code":
Percentages: Format(Abs(([tblTempleFuel
Whenever you get a solution from an expert, please ask any questions at that time, if you are confused about something.
;-)
JeffCoachman
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
AutoNumbers should increment automatically, without duplicates. But sometimes something goes wrong, and the next AutoNumber value is a duplicate. This article shows how to recover from this problem.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month11 days, 14 hours left to enroll
Earn Certification
CompTIA IT Fundamentals
$49.00$44.10
623 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.