Your question, your audience. Choose who sees your identity—and your question—with question security.
Add total of precentages complete
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.
Asked:
2 Solutions
here is the database with th unbound field percentages..the record source does not have a where clause
bingo3.accdb
bingo3.accdb
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.
<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
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now