Solved

Add total of precentages complete

Posted on 2012-12-26
4
242 Views
Last Modified: 2012-12-27
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.
0
Comment
Question by:gigifarrow
[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
 
LVL 1

Expert Comment

by:Dodsworth
ID: 38722313
does the recordsource of the form have a where clause featuring the unbound field perhaps ?
0
 

Author Comment

by:gigifarrow
ID: 38722457
here is the database with th unbound field percentages..the  record source does not have  a where clause
bingo3.accdb
0
 
LVL 30

Accepted Solution

by:
hnasr earned 250 total points
ID: 38722584
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%") AS Percentages, tblTempleFuelcellOnly.Scope FROM tblTempleFuelcellOnly;

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.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 250 total points
ID: 38722598
<I have a unbound field called precentages. >
The Percentages field in the form is bound...
It is bound to a field called "percentages"
Bound field Percentages
Percentages is a field in the form's recordsource/query, ...so there is no "Code":

Percentages: Format(Abs(([tblTempleFuelcellOnly]![Induction]+[tblTempleFuelcellOnly]![Defuel]+[tblTempleFuelcellOnly]![Turret ull]+[tblTempleFuelcellOnly]![FuelCellRemoved]+[tblTempleFuelcellOnly]![BFCSProvision]+[tblTempleFuelcellOnly]![BFCSInstall]+[tblTempleFuelcellOnly]![TurretInstall]+[tblTempleFuelcellOnly]![DriversSeatSpacer]+[tblTempleFuelcellOnly]![GunnersSeatStop]+[tblTempleFuelcellOnly]![CEPRetrofit]+[tblTempleFuelcellOnly]![25MM HotBox]+[tblTempleFuelcellOnly]![E1GroundInsert]+[tblTempleFuelcellOnly]![AFESCEPSwitchGuard]+[tblTempleFuelcellOnly]![ReliefHoleExtinguisherGuard]+[tblTempleFuelcellOnly]![EERHandleMod]+[tblTempleFuelcellOnly]![QA/QC]+[tblTempleFuelcellOnly]![OutDuction])/17),"00.0%")

Whenever you get a solution from an expert, please ask any questions at that time, if you are confused about something.

;-)

JeffCoachman
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

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.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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…

752 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