Recent content by tac5829

what if the items have different values; such as, Item A = 20, Item B = 30, Item C = 50 ? They all have different values in priority of completion, but all needing added for total percent of completion for the entire task per record.

How is the question......I'm not as proficient at this as I thought. hahaha

Yes they can click and unclick the checkbox as required. And the calculated value will need to be on the form and in the query.

I guess I'm lost on this. I will try to be very detailed in my description. I have 10 column headings in my query (they are checkboxes in form) that I want each to have a different value for them (Ie. 20, 5, 5, 5, 5, 5, 5, 5, 10, 10, 15, 10 (when checked)). In an additional column I'd like to...

The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated. Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C...

The other day I check with various people on how I might get column information added together as it relates to checkboxes. Yet, I am still having trouble making this work, please read the following. Any help is appreciated. Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C...

excellent. I will give this a try......if it works......many thank yous. If not.....you'll probably see me back. hahahaha Thanks.

Awesome. that was what I was thinking. Useing second query to do the calculations. Again though, and forgive me, but when I use the type of equation that you specified above, where would I place it? (table? query? and under what category?) Thanks.

So do I place this type of equation in to the format type or in the default value in the Table? Or in the query? Also after the values are applied, how do I go about getting the totals added as I explained in the first post. Thanks for your help.

It shows a checkbox format in the table of yes/no which i think are 0/-1 values, but I don't think I can change this.

I am currently building an Access database. I have built my tables, queries, forms and reports. On one of the forms, I have checkboxes with headings on them; ie: Project Complete. Yet with each heading I want to assign a value. Then the values for each heading will be added per database entry...