Adding Values To Checkboxes?

Aug 13, 2015

I am trying to set up a estimation form. What I want to accomplish is to have multiple checkboxes that a user would select the boxes relevant to his project. From these selections there would be a sum created. Each box could have different values. I tried using the default value but when I unchecked and rechecked it went back to using -1.

I am thinking I will need to assign values through a query but I want to show the sum on my form.

View Replies


ADVERTISEMENT

Adding Up Checkboxes

May 22, 2006

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 (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.

I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:

=iif([ItemA]=True,0.33,0)+iif([ItemB]=True,0.33,0)+iif([ItemC]=True,0.33,0)

This will add these three items up and give you the percentage. You can also do the same in a query to based your reports on these percentages.

Yet, It isn't working properly. Any ideas?

View 3 Replies View Related

Adding Up Checkboxes

May 22, 2006

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 (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.

I was instructed to...........create a text box on a form, set the format property to 'Percent' and the 'Control source' can look like this:

=iif([ItemA]=True,0.33,0)+iif([ItemB]=True,0.33,0)+iif([ItemC]=True,0.33,0)

This will add these three items up and give you the percentage. You can also do the same in a query to based your reports on these percentages.

Yet, It isn't working properly. Any ideas?

View 8 Replies View Related

Can I Add Values To Checkboxes For Tallying?

May 17, 2006

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, to give me the total percentage of project completion. Can I do this with check boxes or radio buttons?

Example: Item A (if checked)= 33%, Item B (if checked)= 33%, Item C (if checked)= 33%. Once adding (if A & B are checked) shows that I have 66% completion on that particular project.
:confused:

View 8 Replies View Related

Summing Values By Considering The Yes/No Checkboxes.

Aug 28, 2006

Hi,

i have created a table that would calculate the total payments that are being made by a certain contractor. I am assuming that the contractor pays the money in three installments.

In a table I have created three fields which are all checkboxes that would state whether a payment has been made or not, for example, checkbox1 would state whether the first payment has been made. And I also have three other fields that states the amount to be paid on each installment

Now, i want to calculate the total amount that have been payed. For example, lets say that the first installment has been made (i.e the checkbox is checked), then the first payment should be added. And if the second payment has been made it should be added as well, thus finally giving the total amount that has been made.

I know how the logic should look like, but i just don't know the syntax that i should use in the query.

Thanks.

View 1 Replies View Related

Access Report Design - Display True Values As A List With Checkboxes

Oct 1, 2015

I have a combo box in my report design and I would like it to display "true" values as a list with check boxes.

View 5 Replies View Related

Forms :: Change ComboBox Drop Down Menu From Displaying Checkboxes For Multiple Values

Oct 14, 2013

I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.

I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).

I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.

I use a very standard SELECT statement to pull the data for the combo box:

SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName

View 7 Replies View Related

Adding Time Values

Dec 29, 2006

I have a report that adds time for as many as six people. This isssue is when the time goes over 24 hours in total it drops the hours. The field(s) is formated in "short time" format.

Can anyone help resolve this???:confused:

View 6 Replies View Related

Adding Values In A Query

Sep 28, 2005

can someone help with this. I have 2 fields in a query

tbl1_nbil = 3
tbl2_nbil = 0

however when I add them using

Bill = [tbl1_nbil] + [tbl2_nbil], I only get a few of the added numbers in the calculated field. In some records it works, but in the majority it does not

It onl seems to add when both fields are greater than zero

tbl1_nbil : tbl2_nbil : Bill
1 : 1 : 2
1 : 0 : 0
2 : 1 : 3
0 : 2 : 0
4 : 0 : 0

View 1 Replies View Related

Adding Values In A Subform

Oct 15, 2004

I have this problem. I've made a table called "producers" and a main form based on this table. I've also made a table called "orders", with several data regarding orders, and a secondary table based on the "orders" table. These tables are linked. So these forms show the orders made by each producers.
So, I want to show in the textbox "total" (in the footer of the sub form) the result of this function
sum([kath_dik])-sum([pistosi]) for each company. [kath_dik] and [pistosi] are text boxes in the sub-form. (scroll the sub form to the right end)
I tried the formula above end get an error message. Thanx in advance

View 2 Replies View Related

Adding Values Within One Column

Mar 3, 2005

I've been having trouble trying to figure out how i can add the values within one column. I have a field named Cost, under that field i have serveral rows of data. I would like access to add all the numbers under that "cost" field. Im not sure how this is done. Can anyone please help ???

thanks
EM

View 6 Replies View Related

Adding Only Selected Values In A Row

Sep 22, 2006

i need to add values of about 20 items and store them in a feild of their own. any ideas of how. Tthe items each have their own value but i need to be able to add all of them up and divide the by the total p[ossible points. i know their is a way to do so but i cant get it to work on my own it keeps giving me an aggregate error.

View 1 Replies View Related

Adding Text Box Values In Report -

Feb 8, 2007

Am I missing something simple here? I have several text boxes, which I want to add the values. I have tried these formulae, but dont work:

=Sum([Postage],[ProgTotal])

=Sum([Postage] + [ProgTotal])

=DSum([Postage],[ProgTotal])

Any help would be greatly appreciated!

View 7 Replies View Related

Adding Discrete Values To A Database

Oct 16, 2007

Hi all,
can i use a listbox control NOT IN A PROGRAMATICALY way, in a table to allow user choose one of some pre_defined values (for example 1,2,4). This field will be used as a parameter in an communication with HW, that's why its crucial not to let users choose whatever value that they want.
Thank you

View 3 Replies View Related

Adding Up Two Values And Displaying It In The Same Table

Jun 20, 2007

Hi,

Im trying to create a database for a stock control system. I have a slight problem, the stock is in two places. So what i have to do is put in the values of stock in each place and then display the value of those two added up in the table. What is the best way to be able to do this?

View 12 Replies View Related

Adding Values With An Update Query

Aug 13, 2007

Hi folks
I have what I reckon is a complex problem that I need to solve for my warehouse.

We hold replacement parts for the machines we sell. Some parts can be subsititued for others, so where we possible we use these parts to simplify our warehousing. Every day we get a file with demand for each part in and we look to see where we could move this demand to for those parts with a common alternative. When we find one we remove the demand from that part in the database and add it to the demand for the common part.

In operational terms we upload the demand file (.xls) to a table of the following structure
Date_added - Date
Part_number - Text
QTY - number

Thus the table holds daily demand by part. What I would like to do is use a update query to:
a) Identify the parts that have common parts to which they can be moved.
b) Add that demand to that of the common part today.
c) remove it from the original part (set to zero).

Idenitfying the parts and restricting to todays date is not a problem, however the additions and deletions are.

Any suggestions?

Thanks in advance!!

View 1 Replies View Related

Adding Values For Multiple Departments

Sep 21, 2007

Hi,
This may be a dumb question, but I've got kind of a question about adding values.

I have a subform that contains a department name, and it's waste totals (in Kilograms) for the day, for a particular company. The company information is the main form.

Whenever I start a new department, the totals, and category names start blank (different departments could produce different waste).

I'm trying create a query that gives me the total value for each Category of waste. However, I keep getting all the seperate values returned?? As apposed to a total. For example.

Company A has two departments:
Office and Production.
For Office they had 20 Kg of plastic bottles and Production had 20 Kg of plastic bottles.
I want to be able to total the weight of plastic bottles...it's just not working../
?
Any advice?

View 1 Replies View Related

Choosing All Possible Combinations And Adding Their Values

Aug 25, 2004

ok this is weird post but im wonderin how to go about it easily cause i can think of a few ways, dunno if they will work of not, so im asking for ur opinion. I need to find out possible cominations for a salary cap football league based on dollar amounts for the players and points based on last years results, yet it cant go past $100.00...so one possible choice is (QB Tom Brady $22.56 183.50 points). its 1 QB, 2 RB, 3 WR, 1 TE 1 Kicker, 1 DEF team and i have to do all 9 for it to count...so would i have to set up 6 columns, one for each position and have a way of picking 1 of A 2 of B 3 of C 1 of D 1 of E 1 of F for 1 qb, 2 Rb, etc? and have it so sum of values is < $100 and it also must add the points so i can see the best possible combination/most points i can get for $100.00...i know its last years points and this year will be diff but I am just comparing...all i need is an outline i dont need u guys to do it for me i have some experience with access...thanks for anyone who can help

View 2 Replies View Related

Adding Up Values From Multiple Queries

Jan 30, 2005

Query 1:
Field #1: User Name
Field #2: CountOfUserName

Query 2:
Field #1: User Name
Field #2: CountOfUserName

Query 3:
Field #1: User Name
Field #2: CountOfUserName

Query 4:
Field #1: User Name
Field #2: CountOfUserName

I want to create a Query that will add
[Query 1].[CountOfUserName]+[Query 2].[CountOfUserName]+[Query 3].[CountOfUserName]+[Query 4].[CountOfUserName]=
[My Query].[TotalCountOfUserName]Group by UserName

It seems difficult.

View 6 Replies View Related

Adding Numerical Values Within Fields

Jun 19, 2006

Hi there

I have an ASP form that saves numerical data to an access database via an insert statement in the asp page.

The main problem i have is that i have some code that adds all the stored values together and provides a total on the screen for the user to print off.

I would like to save this 'total' value to a field in the table but cannot seem to get this to work.

So i thought of running a query in access that would add the sum total of a number of fields and store it to the total field.

Is this possible and how would i go about it?

Cheers

View 3 Replies View Related

General :: Adding Values To Graphs?

May 23, 2013

anyway you can add the values onto a graph

eg i have created a bar graph and on each bar would like the value shown on the top of it

View 9 Replies View Related

Adding Value In Table Based On Values In Two Other Fields

Dec 3, 2007

Hello: Is there (simple) way that I can populate a field based on the values of two other fields? For example, in a list of new employees, if a new employee starts on Nov 30 and works in the Administration Department, his human resources contact is Mary. If a new employee starts on Nov 30 and works in Sales, his contact would be Fred. I hope this is clear! Many thanks!

View 12 Replies View Related

Adding Values In A Form Then Putting It In A Table HELP

Sep 1, 2005

Hey there, Im currently making a form so users can enter project information. For this particular project, the user must choose from a variety of options, and each option has a number value assigned to it for a rating. Now at the end of this form, I want a sum of the ratings, and then entered into the table. I am using a text box for the sum of ratings, and can get the sum of ratings to work on the form, but this data is entered as a 0 in the table. If anyone could help me find a way to put the actual sum in the table, that would be excellent.. thx a lot.

If it would be any help, here are the names of text boxes that I'm adding:

Health and Safety Rating, Maintenance Rating, Equipment Rating, School Size Rating, Student Enrollment Rating, SD Priority Rating, Project Requested Previously Rating

Those ratings must be added into "Total Rating"

Thankyou!

View 1 Replies View Related

Queries :: Adding Totals For Fields With Same Values

Aug 13, 2015

I've got a table with data that's been imported from Excel. I need to run a query that pulls the same values of field one and adds the values of field 2. For instance:

Field 1; Field 2
Jones; 200
Smith;150
Jones; 300
Smith;100

In this example, I need the sum of field 2 for the records where Jones is the value in field 1.

So the result in this case is that records where Field 1 = Jones, Field 2 = 500.

View 2 Replies View Related

Queries :: Adding Values To Present Column

Jul 4, 2013

I use the output of a query (qryTally) to set as my values to a table (tblOrderCountDaily) which sets all the count of a product ordered during a cmdbutton was clicked. If cutoff wasnt clicked for that day, it would create a new field setting the field name as the date. Now, if i click again the the cutoff button, it would check again if the field exists, if yes, i would add the value to the previous value.

Code:
Private Sub CutOff_Click()
Dim db As DAO.Database
Dim tbl As DAO.Recordset
Dim strSQL As String
Dim CheckOut As String

[code]...

View 1 Replies View Related

Adding Numeric Values In Design View Of Query

Mar 3, 2008

I am adding fields with numeric values in design view of my query. The only issue I am having is that the query is not showing totals when one of the fields does not have a numeric value in it. How can I show the total numeric value regardless of the null value? Thank you:cool:

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved